Question

Help creating table and quantities

2 years ago
13 July 2022
2 replies
22 views

JimmyDawg
Beginner
2 replies

Hi All!

I am importing a paragraph of items and quantities (Separated by Commas) and need quantities and items usable individually to export to my CRM

The output I have currently looks like this:

1 x Extended Warranty, 12 x Solar Panels, 3 x Hwt, 7 x Switches

I have tried Formatter - Split Text (As Line Item using comma as the separator but thats only getting me line items showing “1 x Etended Warranty” and I need the quantity to be separate also???

Any help would be awesome!

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

2 replies

Userlevel 7

+14

Troy Tessalone
Certified Zapier Expert
26585 replies
2 years ago
13 July 2022

Hi @JimmyDawg

Good question.

Try this JavaScript Code step...

CONFIG

CODE

let Items = inputData.Items.split(",");
let Qty = [];
let Name = [];

for (let i = 0; i < Items.length; i++) {
  Items[i] = Items[i].split(" x ");
  Qty[i] = Items[i][0];
  Name[i] = Items[i][1];
}

output = [{Items, Qty, Name}];

RESULTS