CUSTOM FILTER

[razzy]

HI ALL,

I am using a custom formula REGEX_Match([VALUES], '^\d.*'), in the filter tool to clean up a column and which should just bring out real numbers also in this column there are negative values that i also want to include in the filter of the numbers. How do i modify this to include positive and both negative. Right now it is only outputting positive numbers.

Thanks in advance.

[Thableaus · Accepted solution]

Hi @razzy 

I think you might wanna try this: REGEX_Match([Field1], "^-?\d+(,\d+)*(\.\d+)?$")

See if it works properly.

Cheers,

[PhilipMannering · Accepted solution]

The regex you use will depend on whether your field should only be the number, contain a number, begin with a number, etc. Helps to see a sample of the data to see what you have and what you expect.

But if you want to match a record that begins with a number you could use -?\d.*

workflow