Amanda Wong
Hi Saul, there isn't a formula to achieve this. However, you can still do so with code using our Ruby connector.
Check out this recipe here: https://www.workato.com/recipes/936843#recipe
The ruby code action in this recipe capitalizes each word in a name and is able to convert:
- O'CONNOR --> O'Connor
- o'connor --> O'Connor
- o connor --> O Connor
- o-connor --> O-Connor
- mcgregor --> McGregor
Still can't find your solution?
Send us a ticket, we will try our best to assist you with your problem
Saul Macht
How to transform names into proper case?
I am looking for a formula to convert names to their proper case. I want to be able to handle Irish/Scottish names e.g. O'Connor, McGregor as well as hyphenated names e.g. O-Connor.