• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Formula Mode Questions
S

Saul Macht

started a topic about 4 years ago

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.

Amanda Wong

said about 4 years ago

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
Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count