Parsing a cell with alpha numeric content

Question

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

Alteryx query 2.xlsx

TheOC · Accepted Answer

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

Here we get the followiing output:

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

Leaving us with:

I have attached the workflow!

Hope this helps!
TheOC

apathetichell · Accepted Answer

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.