Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filtering Numbers Out of a Column

amateur101
6 - Meteoroid

I have a set of data that looks something like this. it's currently formatted as a string.

 

23523words
words
88 words
1
2
3
4
5
8124words
6
7

 

I'd like to filter out only the columns with numbers (1,2,3,4,5,6,7). I've tried converting the string to a number and then applying some filters to clear stuff out, but that was unsuccessful.

 

Should I be considering a different kind of tool?

10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

Hi @CharlieS 

 

I just recently came across this post thanks to my teammate @Deepali77 . I have been using Regex for a while but didnt know you can make a pattern optional by using like (\.\d+)? I was just mind blown when i saw this 😯

 

 


@CharlieS wrote:

 

(\.\d+)? = a decimal place and more digit characters are optional


Thanks you for sharing this amazing thing. Its always a joy to learn from you :)


Cheers and have a nice day!

Labels