Filtering all types of numbers

[Aakash1]

Hi, I have a file with "GBP Amount" Column, which has whole numbers, decimal numbers, positive and negative numbers as well. I want to filter out those cells, which have anything apart from numbers. For eg: I want to filter out, blank cells, cells with characters, dots etc.

"GBP Amount"

0.0023

-1.33

abcd

-0.25897

5369

..

(blank)

-10025

in the above sample, I want to filter out "abcd", "..", "(blank)"

[Emil_Kos · Accepted solution]

Hi @Aakash1 

I have used two different filters to make it more clear how it works:

REGEX_Match(["GBP Amount"], '\d+|\d+.\d+') - it is looking for any number or digigs or any number of digits with decimal space. | This sign represents the or statememnt.

REGEX_Match(["GBP Amount"], '-\d+|-\d+.\d+') - same thing but we are looking at the negative numbers.

This is the workflow: 

This is the final output:

Hope it helps!

[Qiu]

@Aakash1 
@Emil_Kos has given an elegant way, but I have a bit brutal way for your choise.

[KK12]

Hi

There is a quite simple way to do it without application of Regex as well.

Just use select tool and change the type of the column to "Double" and run the workflow. You will notice that all other cells which are not numbers (eg. text/any other special character/dot) will be shown as "Null" in the output. Just filter out the Nulls and you will get the solution.

Let me know in case still facing any challenge.

Thanks,

Kirti Khetrapal