Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Alternate to Substitue Function

Highlighted
5 - Atom

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

Highlighted
Inactive User
Not applicable

Answer attached.

Highlighted
5 - Atom

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

 

Many thanks in advance.

 

Highlighted
Inactive User
Not applicable

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

Highlighted
5 - Atom

Thanks a lot.

Labels