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