Alternate to Substitue Function

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

Accepted answers

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

Answer attached.

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

Many thanks in advance.