Collection Manipulation

[girabor]

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 · Accepted solution]

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]

Thank you for your help.