Best answer

Text to Line-item without comma separator

  • 10 April 2022
  • 1 reply
  • 327 views

Userlevel 1

Hi,

 

I am trying to perform text to line-item conversion using data from several google sheet cells. The issue I’m running into is that the text within the cells may have comma’s in them and are being split as new lines. Is there anyway to change how the separator character? Otherwise, has anyone come across a workaround for this issue? 

 

Blank test is below. Any descriptions that contain  commas are split into additional lines when I don’t want that.

 

I saw a previous article from 1 year ago but it doesn’t seem to have any answer other than “you can’t do it”

Previous Article: 

 

icon

Best answer by Troy Tessalone 10 April 2022, 20:49

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.

1 reply

Userlevel 7
Badge +14

Hi @Llew 

Good question.

A Code step can be used to create line items.