Alteryx Designer Desktop Discussions

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

ReGex Parse tool: Why isn't \D+ matching a less-than (<) symbol?

jlefeaux
8 - Asteroid

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!

11 REPLIES 11
Thableaus
17 - Castor
17 - Castor

@jlefeaux 

 

Yes it does work.

 

Please double check your expression.

 

Solution.PNG

 

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,

jlefeaux
8 - Asteroid

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.

Labels