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 SubstringBeforeLast and SubstringAfterLast Functions

The SubstringBeforeLast and SubstringAfterLast Functions

These two functions help with manipulation of strings like file paths or IP addresses which have multiple occurrences of a delimiter.

For the following examples, assume the data element DocFilePath contains ‘C:\Documents\XpressDox\WordFile.docx’.

SubstringBeforeLast can be used to get the name of folder from a full file path, e.g.:


will get the value ‘C:\Documents\XpressDox’, and


will return ‘WordFile.docx’.

Getting the extension of the file is equally straightforward, using SubstringAfterLast: