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.
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:
Send us a ticket, we will try our best to assist you with your problem