Filtering out values that contain anything but a number

[wht822]

Hello,

One column in my dataset contains multiple different types of data (addresses, dates, numbers, etc...). and I want to filter out anything that contains a non-numeric value. This way, titles and dates are all done away with and I'm only left with columns that are only a numeric value. I feel like this could be a simple solution, but I'm having difficutly coming up with it. Does anyone have any ideas?

Thanks!

[MarqueeCrew]

Filter using:

regex_countmatches([field],"\D") > 0

 cheers,

 mark

[wht822]

Looks like that filtered out everything but whole numbers. Any idea how I could keep non-whole numbers as well?

[MarqueeCrew · Accepted solution]

This version allows for {0-9,commas,decimal points}

Filter using:

regex_countmatches([field],"[^\d,\.]") > 0

 cheers,

 mark

[rdeeparnell]

do I still need to change the data type of the field that I am filtering?  I keep getting the following error: Formula:tried to apply string operator to numeric value