String Manipulation RegexReplace

[ahortonmilsig]

Hi, I have a column with a mix of letters, numbers and special characters, all in various positions. See image below.

I need to remove the letters, and most special characters leaving only the numbers but if there are spaces between the numbers I want to keep that.
ex. starting cell is 35377659 (main) / 35429370 / 21703523
want it to look like: 35377659 35429370 21703523

Is this possible with string manipulation?

Thank you for help in advance!

[dnaki]

Hi,
Yes, using a regular expression replacement function like so:

-Don

[ahortonmilsig]

thank you so much! One last question… I have a row that is like 89765845,7535452 and when I use that regex you provided it joins that altogether. How can I have it leave a space? Or is that not possible?

[berserkersap]

Hello ahortonmilsig,

I don’t think you can fit that into the regex in a single node.
Instead in a node before this regex, you can use

replace($Sold To$,","," ")

[dnaki]

Hi,

Perhaps the simplest way would be to precede the above String Manipulation node with another String Manipulation node that first takes care of commas between numbers: