Edit Content
Click on the Edit Content button to edit/add the content.

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:


Table of Contents