+2I 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
Best answer by Alexey_Gusev
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]", "")
If you want to remove lowercase letters and spaces, that's easy.
REGEX_REPLACE({Name},"[a-z ]","")
+25If 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.
+29Lol. I was lazy and figured someone else would type the answer.
+2I 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 😃
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
