Title case

[Kim_Trager1]

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?

[Clasicwebtools]

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

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.