Keeping only #s in a string

[nwatzlaf]

Hello there,

I have a data set with store numbers and store name in one column. I am looking to only keep the store numbers from the column. I was going to use a trim function as all of the store numbers are at the beginning of the string. But the store numbers vary from single digits to four digits.

Sample data below:

1 : Store A

23 : Store B

165 : Store C

2319: Store D

Is there a way to keep just numerical digits of the text string?

Thank you for your time,

Natalia

[ShankerV · Accepted solution]

Hi @nwatzlaf 

Please use the Regex tool

(\d+)

Many thanks

Shanker V

[nwatzlaf]

Brilliant @ShankerV 

Thanks so much!

[ShankerV]

Hi @nwatzlaf 

Solution 1 to overwrite in the same column:

Solution 2: To write in the new column using Parse option

Many thanks

Shanker V