This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi,
I am using the below formula in Excel and getting the desired Output. However I am unable to replicate the same in Alteryx.
Input: P DIEM-SGD 123@ 48.98-0112-061217-BASKAR S
Output: BASKAR S
=RIGHT(B2,LEN(B2)-FIND(CHAR(1),SUBSTITUTE(B2,"-",CHAR(1),4)))
Please Assist
Thanks.
Regards
DNS
Solved! Go to Solution.
Thanks for the reply. Can you please help me understand this REGEX function?
Many thanks in advance.
Regular Expression. It is essentially looking for patterns in the data. You can Google how it works further, very handy stuff.
Thanks a lot.