split/filter a column with numbers and text

[JokeFun]

I have a column where both numbers and text exist. I'd like to split them into two streams, one with numbers only, and the other with text or text plus numbers.

Say column A has below values

100

Amazon

Book21

200

Help/Date

...

I want to filter out the text values and keep the numbers only.

[Qiu]

@JokeFun 
RegMatch maybe is the tool we need

[JokeFun]

@Qiu Thanks, I just tried, it works for numbers with no decimals, but also excludes numbers like 123.12. How can we do that o include all numbers?

[atcodedog05]

Hi @JokeFun 

A super easy way to get numbers only is to use select tool convert field to numeric field (double) this will convert all non numbers to null. Then filter on null. This will handle decimals as well as negative.

Output:

Hope this helps 🙂

[Qiu · Accepted solution]

@JokeFun 

Trust the force, trust the RegEx. 😁

[Qiu]

@atcodedog05 
The king has returned. 😁

[JokeFun]

@atcodedog05 I was using Select tool. But this will populate Conv error messages when the field is text.

[atcodedog05]

Hi @JokeFun 

Its a warning message which you are getting for converting string to number. Warning message is not a major issue it doesnt affect your execution.

[atcodedog05]

Hi @Qiu 

Those are some super highly big words 😅 i cannot accept them 😅

[atcodedog05 · Accepted solution]

Hi @JokeFun 

If your unconformable with warning messages. We can extend on @Qiu's solution to accommodate negative numbers. 

Hope this helps 🙂