Anaplan's "SUBSTITUTE" formula has three arguments whereas excel's has a fourth optional argument that would allow for much simpler identification of specific substrings within a string that varies in construct:
Anaplan = SUBSTITUTE(Text to search in, Text to find, Replacement text)
Excel = SUBSTITUTE(Text to search in, Text to find, Replacement text, [Instance to start from])
Text line item =
SUBSTITUTE(text line item, "_", "|", 3)
---> TR_111_909_G ---> TR_111_909|G ---> G
---> D_1_2_UYH_LO ---> D_1_2_UYH|LO ---> LO
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.