SubstringBeforeLast and SubstringAfterLast 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,...

SubstringBeforeLast and SubstringAfterLast 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,...