Filter numbers

Hi All,

I am trying to figure out how i can filter a string column which only contains numbers. For example see below. How can use the filter tool to filter out everything and keep records 1&4? Bare in mind these are in the string data type.

Example Column:

1) 0.1333377882

2) N/A

3) N.A.

4) 13336878

Workflow

Accepted answers

Thableaus

Hi @jonathanzadeh

If you use a Select Tool and convert to a Double type, you'll see that all numbers will be kept and strings will be converted to Null.

Then, you can filter the Null values and you'll be left with numbers.

That's just a way to do. There are a lot of other ways, but I think this is a simple one.

Cheers,

All comments

Thableaus

Hi @jonathanzadeh

If you use a Select Tool and convert to a Double type, you'll see that all numbers will be kept and strings will be converted to Null.

Then, you can filter the Null values and you'll be left with numbers.

That's just a way to do. There are a lot of other ways, but I think this is a simple one.

Cheers,

Kenda

Hi @jonathanzadeh

Put this in for your expression in a Filter tool:

REGEX_Match([Field1], ".*\d+.*")

This works for me with your sample data. Test it out on your full data set.

jamielaird

Hi @jonathanzadeh

This will work:

REGEX_Match([Field1], '\d+|\d+.\d+')

Screenshot 2019-05-17 at 13.52.20.png

jamielaird

@Kenda @Thableaus You guys are on the ball today!

jonathanzadeh

This does work. Would you mind explaining this? Would like to understand what i am doing

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703