• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
Solution home Formula Mode Tips & Tricks Text Manipulation Formulas

How do I format my text into multiple lines? (Line Break)

Modified on: Thu, Aug 29, 2019 at 6:33 AM

Many times, when you are trying to copy text from one system to another you want to concatenate multiple elements but you also want to format it onto multiple lines. A good example is address lines - in Xero, the address lines are split into address line 1, address line 2, address line 3 but in Salesforce there is just one field called billing street. Here's how you do it: 


Text Mode

Create a new line by using the Enter/Return key, just like any regular text editor.


While using Text mode to format new lines is much easier, using formula mode allows you to manipulate individual pills as you desire.


Formula Mode

Simply add a "\n" when in formula mode between quotes to signal that you want a new line between two parts of the string. 


You can also use "\n" to join values of an array using the formula below:



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

    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