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

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

Filter using:

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

 cheers,

 mark