- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 01, 2023 04:57 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 01, 2023 12:30 PM
I thought exactly the same way, but was too lazy and asked chatbot. Seems like chatbot offered better solution
REGEX_REPLACE({YourTextField}, "[^A-Z]", "")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 01, 2023 06:46 AM
If you want to remove lowercase letters and spaces, that's easy.
REGEX_REPLACE({Name},"[a-z ]","")
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 01, 2023 12:30 PM
I thought exactly the same way, but was too lazy and asked chatbot. Seems like chatbot offered better solution
REGEX_REPLACE({YourTextField}, "[^A-Z]", "")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 01, 2023 04:13 PM
That's certainly better
AIChatbot is very informative.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 01, 2023 04:53 PM
Lol. I was lazy and figured someone else would type the answer.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 02, 2023 02:00 AM
Worked beautifully, thank you 😃
