topic Collection Manipulation in Product Forum

Collection Manipulation

girabor — Sat, 10 May 2025 22:34:46 GMT

I have a collection that contains menuitems and prices in one field(column),

For example: Value - "Rice N3000"

I want to seperate the rice into a field menuitem and N3000 into prices and store them in a different collection.

Chakkravarthi_PR — Mon, 12 May 2025 07:33:44 GMT

1. I have used a defined collection (Items)

And added initial values to it:

2. Create another defined collection with the fields :

3. Then using Action Collection - Add Row to the Output Collection:

4. Loop through the collection and use the Multi Calc stage and store the result in Output Collection:

Trim(Left(Trim([Items.Menu]), InStr([Items.Menu], " ")-1)) = Output. Item

Mid([Items.Menu], InStr([Items.Menu], " ") + 1, Len([Items.Menu]) - InStr([Items.Menu], " ")) - Output. Number

5. Output looks like this after iterations:

6. Then Use the Output collection for further processing

girabor — Tue, 13 May 2025 07:24:33 GMT

Thank you for your help.