String manipulation (REVERSE)

Required where a string has an unknown number of parts separated by a delimiter that needs to be parsed from end to beginning to identify the individual elements. Common need for us when parsing and standardizing street addresses. Alternative would be to add option to existing action split delimited text to find/keep text after last occurrence of delimiter rather than assuming first instance.

eg string: 1201-100 OLD YONGE STREET, TORONTO, ON M1P3J3

You can use the mirror() function to find delimiters from the end. For instance:

 mirror(keepbefore(mirror([Full address]), ','))
1 Like

Alternatively, use actions as in the example below:

last-delimited-part.morph (3.5 KB)

**** moved to #uncategorized

1 Like