The SubstringBeforeLast and SubstringAfterLast Functions

October 6, 2014 User Reference

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 […]

Read the full article →