Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music

Fields that contains only numbers

Highlighted
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

Highlighted
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.
Highlighted
8 - Asteroid

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

Labels