Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Title case

Topic Labels: Formulas
1040 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kim_Trager1
9 - Sun
9 - Sun

I have a column of text I need to convert in to title case for an import into another system.

Is there a way to make this title case with Regex?

There is things like:

"PREPARE FOR PRINT"

"BLUE/GREEN"

"WHITE / BLACK"

Anyone know if this is possible?

1 Reply 1
Clasicwebtools
5 - Automation Enthusiast
5 - Automation Enthusiast

If you need to make the whole text title case you can do like this

Clasicwebtools_0-1713121324660.png
If you have to extract a specific text and make that only UPPER() it's a bit harder. I would try to convert that with regex in the process to sending to the other system, maybe you can add some script to transform.