Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Extract Currency from Sec id

bubblyjai1982
8 - Asteroid

Hi All

 

I'm trying to extract the currency from sec id using regex tool but not able to extract only currency.

 

I have differentiated the alphabet and date using the expression ([[:alpha:]]+)(\d+) but from alphabet i want to pull only currency which is not at constant place in sec id.

 

I have attached input data and also required output.... 

 

Kindly assist 

 

Thanks in advance 

10 REPLIES 10
bubblyjai1982
8 - Asteroid

Thank you !! This was helpful

Labels
Top Solution Authors