community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

CUSTOM FILTER

Asteroid

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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @razzy 

 

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

See if it works properly.

 

Cheers,

Alteryx Certified Partner

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.*

 

 

Regex starting numbers - Capture.PNGworkflow

Labels