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

Alteryx designer Discussions

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

The latest release includes several enhancements designed to improve your Community experience!

Learn More

Fields that contains only numbers

Meteor

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

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

Labels