Skip to main content

I want to be able to extract capital letters from a string (name of a type of event) to create its ID CODE.
This way I can keep my ID CODE as a formula, not manually, and still control how it comes out through the capitalizing of letters in the name.

For example:

 NeuroGym = NG
 Business Meeting = BM
 Annual global Event = AE
 Monthly internal Event = ME
 Business Event = BE

If you want to remove lowercase letters and spaces, that's easy.

REGEX_REPLACE({Name},"[a-z ]","")

If you want to remove lowercase letters and spaces, that's easy.

REGEX_REPLACE({Name},"[a-z ]","")

I thought exactly the same way, but was too lazy and asked chatbot. Seems like chatbot offered better solution

REGEX_REPLACE({YourTextField}, "[^A-Z]", "")

I thought exactly the same way, but was too lazy and asked chatbot. Seems like chatbot offered better solution

REGEX_REPLACE({YourTextField}, "[^A-Z]", "")


That's certainly better

AIChatbot is very informative.

Lol. I was lazy and figured someone else would type the answer.

I thought exactly the same way, but was too lazy and asked chatbot. Seems like chatbot offered better solution

REGEX_REPLACE({YourTextField}, "[^A-Z]", "")


Worked beautifully, thank you 😃

Reply


Terms & Conditions