This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The following should work for your RegEx string, and then just use "$1" as your replacement value to keep only the digits in the marked group ()... there may be more glamourous ways to do it with RegEx, too, this is just one option!
Also, worth noting... there is a Data Cleansing tool that will do a similar thing, in the Preparation tool section. You can check a box to remove all letters in a string or strings - also has options to remove all punctuation, all numbers, duplicate whitespace, etc. Definitely worth checking out!
Ok I just found out that if I checked the output unmatched box at the bottom of the Regex tool it would work. I have also come up with an alternative using Regex_Replace formula with "\u". This allows me to add a new column with the Formula tool.