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.

[atcodedog05]

This post just helped me to rank up to 18 - Pollux

Awesome😎. Thank you both 🙂

[Qiu]

@atcodedog05 
I think last time we just talked that it is rare to see rank 18.
Now you are one of them.

Congratulations!

[JokeFun]

@atcodedog05 @Qiu Great thanks to both! This is exactly I am looking for.

[atcodedog05]

Hi @JokeFun 

My solution was extended based on @Qiu's post hence can you please also mark his post as solution.

Thanks

Happy to help 🙂

[JokeFun]

oh, I did not know a post can have more than one solution! Good to know that.

Congratulations on reaching the 18th!

BTW, I have a special case here where -0.07 in excel file was read in as -7.0000000000000007E-2 and the regex_match filter excluded it while Select can successfully convert it to -0.07. Just wonder if there's a way that it can be included and also converted to the right format.

[atcodedog05]

Hi @JokeFun 

Honestly speaking Regex is a method where we as a user are defining the number format. And Select tool is a method where alteryx/system is defining the number format. Alteryx/system will know all the scenario of numbers and can handle it. On other hand regex is manual and we might have to do much computation which is already done by the system.

And trust me warning message is not a major concern.

Hope this helps 🙂

[JokeFun]

Got it. Thank you!

[Qiu]

@JokeFun  @atcodedog05 
Thank you both.

Can we modify the formatting in Excel, that would be the straight forward way.