RegEX in Formula Tool

[Arun_KV]

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

[Thableaus · Accepted solution]

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]

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

[Thableaus]

@Arun_KV 

Unless you define case sensitivity, it doesn't.

Cheers,