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.