XpressDox Help Center

Use Google To Find Help Fast, e.g. xpressdox choosefromlist


Press Getting Started in the XpressDox toolbar for basic template development
Watch the tutorial videos
View command help from list of commands
Press F1 for help on a command in the Command Editor
Email support@xpressdox.com for assistance

The Left and Right Functions


The Left and Right Functions

The substring function provides all the functionality to extract pieces of a string, but Left and Right make some operations easier. Left returns the leftmost characters, and Right the rightmost characters.

In particular, extracting a substring at the end of a string can be quite complicated, needing knowledge of the length of the string, for example.

If a data element Name contains “Frederick Basset”, then the function

«Right(Name,3)»

will return “set”. This is equivalent to «substring(Name,string-length(Name)- 2,3)»

«Left(Name,4)»

will return “Fred”.

If the number of characters requested is more than the length of the source string, then the entire source string is returned.