I'm new to RegEx and this is driving me crazy.
I'm trying to find non-numeric characters in a data field that should be numeric.
In this case one of my users entered '< 85' in their spreadsheet.
I've set up a RegEx Parse to look for \D+, which to my understanding should match any field that contains one or more non-digits. My output method is Match, but this expression is not matching the '< 85'.
I tested it on https://regex101.com/ and it matches in their tester, so I'm not sure what's going on here.
Tiny example workflow attached.
Thank you!
Solved! Go to Solution.
Yes it does work.
Please double check your expression.
Also, you could set your expression to "^\d+$"
This way the whole string has to be composed by 1 or more digits. This would give full numeric records a True, and otherwise a False.
Cheers,
Oh boy, I really am going crazy.
I tried it again, and yes, it did work. But I swear the first time I copied it from the webpage and made sure there wasn't any whitespace afterwards, and it didn't work.
I can't explain this, but I wanted to apologize, and say thank you again.
Now I'm GOING HOME and going to start over tomorrow.
User | Count |
---|---|
19 | |
15 | |
15 | |
9 | |
8 |