Line Itemizer returning values with ", [ and ], which can't be used in add multiple rows in googe sheet

[Emily]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZkMDYzZjA0MzU1MjY1NTUzNzUxMzIi_pc

I used "Lookup Spreadsheet Rows" and then "Line Itemizer" the result contains ", [ and ]

Can't use these with my next step - add multiple rows in googe sheet. Shows error code 400
Is the only thing I can do is to replace it one by one?

 

[Pabblymember11]

Hey @Emily

Regarding your concern, we recommend you to use replace the [" and "] brackets from your array with the help of Text Formatter.

Further, as we can see from your workflow you have already implemented the best possible trick to manage the line item.