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