ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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