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!