Alteryx Designer Discussions

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

Fields that contains only numbers

8 - Asteroid

Hello

How can I spot fields that contains only numbers, including negative or positive values. So for the sample values only 95 must be captured or flagged

Capture2.JPG

Alteryx Certified Partner
Alteryx Certified Partner
Sorry for being terse.

Regex_match([field],"[\-{0,1}\d+")

Should find zero or 1 minus signs followed by 1 or more numbers, but nothing else.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
8 - Asteroid

this worked better
REGEX_Match(ToString([Total_Percent of Operation]), "-?[0-9]+")

Labels