• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
New Topic
Discussions Recipe Building Formula Mode Questions
S

Saul Macht

started a topic about 3 years ago

Formula to clean data containing smart quotes and line breaks

Hi, I am working with text data that possibly contains smart quotes or curly quotes that I need to clean up. I want to remove any line breaks as well. What is the formula I can use? gsub?

Amanda Wong

said about 3 years ago

Yes, you can use gsub to achieve that. Take a look at this recipe example here.


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 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato