Alteryx Regex vs Regex101

MartWClimber

Gooday,

I find that my Regex is a bit rusty. Because when I tried with Regex101.com I got an other result than in Alteryx.

I'm trying to parse the underscore away and I only needs the last 2 characters.

so in this example I only need AA_FH to be FH and the AA_OUT_FH to also be FH.

In Alteryx I get this back

Did something change in the Regex tool?

Designer Cloud

Regex

Accepted answers

DataNath

The reason this won't work in Alteryx, that Regex101 doesn't show so well, is that in your second test (AA_OUT_FH), there's actually 2 matches of the pattern you're providing (i.e. an underscore followed by letters) and so when you parse it, Alteryx will just provide the first match as the output. You can see what I mean if you switch the mode to tokenize (i.e. output all matches of the pattern) - you have 2 for the second line.

To get around this, you can use a more specific expression. The following works if you just want to find the final 2 letters after the last underscore:

.+_([A-z]{2})

All comments

DataNath

To get around this, you can use a more specific expression. The following works if you just want to find the final 2 letters after the last underscore:

.+_([A-z]{2})

MartWClimber

Thank you for the explanation,

is there an other tool like Regex101 that shows in a better way what the Alteryx regex tool will output?

philipmannering

The reason for the discrepancy is because you've got Case Insensitivity ticked

Use,

_([A-Z]+)$

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335