Alteryx Designer Desktop Discussions

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

Regex Help

Metadata21
8 - Asteroid

Hello my fellow data buddies,

 

I require some data in the formula tool to extract a combination of letters and numbers from the image attached highlighted in yellow - I have tried it but its not working - i am not surprised as my lack of regex knowledge is below par.

 

thanks for your help!

1 REPLY 1
DataNath
17 - Castor

I'm a little confused by your question. When you say extract, do you mean you want to parse this out? If so, the RegEx tool itself is an option, like so - assuming it's always <numbers><letters><numbers>:

 

DataNath_1-1652800190078.png

 

 

You can also parse it with the following in formula (which is more dynamic to other combinations i.e. <letter><number>). If you just want a flag if there's a combination (i.e. not just numbers), the following should work:

 

DataNath_0-1652800640987.png

 

If not, let me know and I'll take another look!

Labels