Import Multi-line Text into NetSuite

David Gollom Strategic Partner

• May 14, 2021 01:01

Hey There,

I'm sure this is stupid simple.  I'm trying to import some multiline text into the Message field of the NetSuite Task record.  How do I insert a new line in my handle bar expression field mapping??  

Looking to achieve 

Name: Dave

Rank: General

Serial: 234234

using a handlebar express like...

Name: {{data.name}} // insert proper new line char here

Rank: {{data.rank}}  // new line here

Serial: {{data.serial}}  

 

Thanks!! 

0

• 

  Anirudh Sundaram Senior Integration Engineer

  • May 14, 2021 15:41

  

  

  Hi David,

  You can use the "join" helper like this - 

  {{join '\n' (join ": " "Name" data.name) (join ": " "Rank" data.rank) (join ": " "Serial" data.serial)}}

  0
• 

  Eric Popivker

  • May 25, 2023 13:58

  

  Hey Anirudh Sundaram, thanks, but that doesn't work. It reformats data by adding \, so I get \\n instead of new line.

  0
• 

  Dan Claypool Support manager NetSuite Integration Whiz

  • June 07, 2023 19:34
  • Edited

  

  

  Hi David, Eric,

  Please try the following:

  Name: {{Name}}
Rank: {{Rank}}
Serial: {{Serial}}

  Here, we're sending the LF Unicode character to provide the Line Feeds.
  
  This should populate the Message field on the Task record with the line breaks. Since this is a "long text" field, it requires some special handling. Please also note that when you view the record directly, it will appear as if there are only spaces. When editing the record, you should see the breaks.
  
  Additionally, if you're importing into a Rich Text field in NetSuite, you can use <br> to insert line breaks between text.

  1
• 

  David Gollom Strategic Partner

  • June 08, 2023 15:02

  

  

  

  

  

  Thanks for the help Dan!!  

  0

Please sign in to leave a comment.