Filtering Numbers Out of a Column

[amateur101]

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?

[atcodedog05]

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!