Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
Top Solution Authors