substr

[kmv]

if i use substr to simply show the first 20 chars of an address, =substr(Address,20) its fine as long as the address is longer than 20 chars and isnt null, but delivers errors if the address is either short or null

[Svetoslav]

Hello Kevin,

The current implementation of Substr() built-in function is based on System.String.Substring() method without performing any additional validation of the input data, which happens to be the problem in your case. I have logged this issue in our bug tracking system and it will be fixed in the next version scheduled for the end of July. We have updated your Telerik Points.

Fortunately you can use your own custom substring function, where you can handle all the exceptional situations and prevent any errors. For more information on the user defined functions, please see Using Expressions.

All the best,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Scott]

I'm not sure this is a bug. Trying to substring 20 chars off a 5 char string is an error.

Regardless, this might be a simpler work-around:

=substr(Address+"                    ",20)