Alternate to Substitue Function

[DNS]

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

[Inactive User]

Answer attached.

[DNS]

Thanks for the reply. Can you please help me understand this REGEX function?

Many thanks in advance.

[Inactive User · Accepted solution]

Regular Expression. It is essentially looking for patterns in the data. You can Google how it works further, very handy stuff.

[DNS]

Thanks a lot.