Help

Extract capital letters from a string

Topic Labels: Formulas
Solved
Jump to Solution
1984 5
cancel
Showing results for 
Search instead for 
Did you mean: 
dannytvb
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions

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

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

See Solution in Thread

5 Replies 5
Sho
11 - Venus
11 - Venus

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]", "")

That's certainly better

AIChatbot is very informative.

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

Worked beautifully, thank you 😃