Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

RegEX in Formula Tool

Arun_KV
8 - Asteroid

Hello Team - 

 

I am using RegEX in formula tool to identify the string that could be an address. I am trying to check  if the string has two upper case letters in sequence followed by a space and then  5 digits .  But the formula appears to be not working as expected for the 6th row in the input . Please see below . Any clue on what am I doing wrong here ? Appreciate your inputs.   

 

Thanks,

Arun

 

Arun_KV_0-1592236764895.png

 

Thableaus
17 - Castor
17 - Castor

Hi @Arun_KV 

 

Add a 0 at the end of your REGEX_Match expression.

 

REGEX_Match(Field, "expression", 0)

 

0 indicates case sensitivity.


Cheers,

Arun_KV
8 - Asteroid

Thanks ..It did the trick .  But  \u  does not have any relevance  here ?  

Thableaus
17 - Castor
17 - Castor

@Arun_KV 

 

Unless you define case sensitivity, it doesn't.


Cheers,

Labels