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


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


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.