I'm currently working on a Zap where a trigger returns line item data in a comma-separated string format. For example, the quote might include a single field like this:

Codes: A01, B02, C03, D04 Quantities: 1, 2, 3, 4 Prices: 100, 200, 300, 400

What I want to achieve is for Zapier to treat these as four distinct line items in the next step—each with its corresponding code, quantity, and price—so that I can pass them into a table or line item field (e.g. in Xero, Google Sheets, or an invoice tool).

Could you please advise:

1. Whether this kind of transformation is possible natively in Zapier.

2. If yes, what is the best approach? (e.g., Formatter > Text > Split + Looping by Zapier?) Or perhaps int a table

3. If not, do you recommend using a Code step or a third-party tool like Webhooks or a Zapier-integrated parser?

I'd love a step-by-step guide or example setup for handling this type of conversion.

Thanks so much in advance!