Regex 3 or more characters

[hellyars]

Hi,

I want to extract acronyms that have 3 or more uppercase characters.

I tried

([A-Z]{3,0})  Correction....I actually tried

([A-Z]{3,0})

 ...and it did not work (it does on Regex101)

[IraWatt]

Hey @hellyars,

I think you are looking for:

([A-Z]{3,})

Got this from regex101: build, test, and debug regex:

[MarqueeCrew]

\u{3,}  but Alteryx default is case-insensitive

REGEX_Match(String,pattern,icase)  where icase is 0 for case sensitivity

[PhilipMannering · Accepted solution]

What @MarqueeCrew said. So easy to forget about unchecking "case-insensitive" box in the Regex Tool or flag icase as 0 in the Formula Tool.

[hellyars]

@IraWatt  Sorry, I cut and pasted the wrong version.  I did try exactly that ([A-Z]{3,}) and it did not work

[hellyars]

@PhilipMannering   LOL That was it.  ([A-Z]{3,0}) does work so long as you uncheck the case insensitive box. 

[IraWatt]

@hellyars could you provide some sample data It seems to work for me