We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Parsing a cell with alpha numeric content

SP3000
8 - Asteroid

Please help, my input data is Mons3344onam + 123409955 sd124frrwww and the desired output is the numbers after "+" sign which is 123409955.

4 REPLIES 4
TheOC
16 - Nebula
16 - Nebula

hey @SP3000.
I would use a text to columns for this, where you can split the incoming data by a space

TheOC_2-1620564513712.png

 



Here we get the followiing output:

TheOC_3-1620564518777.png

 

 

Then we can simply use a select if necessary to remove all other data columns:

TheOC_4-1620564558458.png

 

Leaving us with:

TheOC_5-1620564572183.png



TheOC_6-1620564578656.png



I have attached the workflow!

Hope this helps!
TheOC

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
apathetichell
20 - Arcturus

Wasn't sure if it was possible to have more than 1 entry per row so I used a regex/tokenize split to rows. If only 1 entry was possibly I'd use split to columns.

SP3000
8 - Asteroid

Thank you so much.

SP3000
8 - Asteroid

Thank you so much..

Labels
Top Solution Authors