Use Google to find help fast. For example, search on "xpressdox choosefromlist".

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.:

«SubstringBeforeLast(DocFilePath,'\')»

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

«SubstringAfterLast(DocFilePath,'\')»

will return ‘WordFile.docx’.

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

«SubstringAfterLast(DocFilePath,'.')»