Keep only Capitals of String

Hi All,

I've been trying to do the following, with no success, for a while now.

I have Company Names as a string (i.e Albatross Banana Cookie) in my field Company, I want to go from the full name to an acronym that keep only the capitalised letters (i.e ABC). Any ideas if this is possible?

Thanks,

Regex

Accepted answers

MarqueeCrew

Regex_replace([name],"[\l\s],'',0)

That will cause all lowercase letters and spaces to be replaced by nothing. Make sure to cleanup business suffixes first (e.g. Inc).

Cheers,

Mark

jdunkerley79

Good point - wasnt in front of Alteryx and always forget that!

REGEX_Replace([CompanyName],"[^A-Z]","",0)

as @MarqueeCrew says need the ,0 to make it case sensitive

All comments

jdunkerley79

You can do this with a REGEX_Replace in a formula tool something like:

REGEX_Replace([CompanyName],"[^A-Z]","")

This will match and replace everything that isnt a capital letter with an empty string

MarqueeCrew

Regex_replace([name],"[\l\s],'',0)

That will cause all lowercase letters and spaces to be replaced by nothing. Make sure to cleanup business suffixes first (e.g. Inc).

Cheers,

Mark

MarqueeCrew

James,

I like your style. But, you don't have case sensitivity turned on. Is that another reason to define by characters instead?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703