Excel equivalent for TEXTBEFORE
Need to pull text out of a string. Starting from the beginning but going varying # of characters. Last character will always be immediately before an underscore. So in Excel I could use the TEXTBEFORE function. No exact counterpart in Anaplan but wondering if someone has already solved this with a workaround?