Best answer

Google Docs / Invoice items from Quickbooks / Replace commas with line breaks.

  • 26 July 2020
  • 3 replies
  • 202 views

Userlevel 1

Hello,

I am creating a new Google Doc for each Quickbooks Online Invoice created. The doc is created and the fields merged. 

However, it merges all the invoice line items into one value separated by commas. 

Item1,Item 2, Item3

That creates a document that is very difficult to read. 

What I need to do, at a minimum, is to add a line break between the items. EG:

Instead of :Item1,Item2, Item3 

It would insert:

Item1

Item2

Item3

 

Any advice?

thanks

icon

Best answer by ikbelkirasan 26 July 2020, 20:06

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 1
Badge

Hi 

Use Code by Zapier and apply {yourvalue}.replace(‘,’,’\n’)

 

You will receive output as line breaks.

Userlevel 7
Badge +12

@ShaunS1456 - You could also use a Formatter step → UtilitiesLine-item to Text then set the Separator to [:newline:]

 

Userlevel 1

That did it! Thank you!