Need help with converting this xls formula =IFERROR(IFERROR(IFERROR(IFERROR(LEFT([@[Program Name]],SEARCH("XOL",[@[Program Name]])-1),LEFT([@[Program Name]],SEARCH("XL",[@[Program Name]])-1)),LEFT([@[Program Name]],SEARCH("Excess",[@[Program Name]])-1)),LEFT([@[Program Name]],SEARCH("_",[@[Program Name]])-1)),"") to an alteryx one.
Attaching the xls file and the desired result with the above formula in it.
Thanks!
Solved! Go to Solution.
Hi @dtrix
This isn't really a concept in Alteryx. You could use if statements to get the same answer:
Thanks everyone for different sorts of solutions. Very very helpful
Since I am not familiar with Regex, I will try @Luke_C 's solution. Would you know how to make the Findstring functions case INsenstive because sometimes XOL is capital, sometime XoL?
Thanks!!