Extract all words from string that are in CAPITAL but word length must be at least 3 characters

[Asanka]

Would I use regex for this?

Extract all words from string that are in CAPITAL but word length must be at least 3 characters?

[Anthony_Humphries]

Use System.Text.RegularExpressions.Regex.Matches(MyStr, "[A-Z]{3}"), where MyStr is the string on which you’re searching.

[Asanka]

@Anthony_Humphries

[A-Z]{3}

hey its splitting up words like UNITED STATES to UNI TED STA TES

[Anthony_Humphries]

Use System.Text.RegularExpressions.Regex.Matches(MyStr, "([^\w]|^)[A-Z]{3}(?!\w)").Trim instead.

[Asanka]

@Anthony_Humphries

System.Text.RegularExpressions.Regex.Matches(MyStr, “([^\w]|^)[A-Z]{3}(?!\w)”).Trim

how do i do this in the matches activity? I get an error when I try and assign it

[Anthony_Humphries]

This returns a MatchCollection. You need to use a For Each loop to iterate over each of the matches.

[Asanka]

@Anthony_Humphries

System.Text.RegularExpressions.Regex.Matches(MyStr, “([^\w]|^)[A-Z]{3}(?!\w)”).Trim

hey so it won’t let me put the Trim in there. When i took the trim out, it only brought me words with 3 characters like CAD. I want 3 characters or more.

Ha this one is tricky

[Anthony_Humphries]

Ah, my mistake. Remove the .Trim part, and use that on each of your matches instead.

[Asanka]

But how do I make it show words that are 3 letters or greater? With what you gave me it will give me words like LKR, CAD, USD, but not UNITED STATES

[Anthony_Humphries]

Change the regular expression to [A-Z]{3}\w*.

[Asanka]

@Anthony_Humphries

[A-Z]{3}\w*

Beauty thanks!