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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels