How to extract text in a column field from a collection to another collection

[Mareenchen]

This is my Input in one text field in a collection:
last name, first name, email@mail.com; last name2, first name2, mail2@mail.com; last name3, first name3, email3@mail.com;

My expected Output to extract the data in one Collection like this
Column1 Column2 Columns3
row1 last Name first Name email@mail.com
row2 last Name2 first Name2 email2@mail.com
row3 last Name3 first Name3 email3@mail.com

My steps to extract the data:
1. Utility - Strings, Action "Remove Non-word Charachters" --> Output: last name, first name, email@mail.com; last name2, first name2, mail2@mail.com; last name3, first name3, email3@mail.com
2. Utility - Strings, Action "Split Text" with Semikolon --> Output: Column1
row1 last name, first name, email@mail.com
row2 last name2, first name2, mail2@mail.com
row3 last name3, first name3, email3@mail.com
An now I'm not sure what I have to do.

 

[SaiSiddhu]

I'm haven't worked with this kind earlier. But, I can give you a brief idea.
Use split lines followed by split text.
Let me if it is helpful!

 

[rsingh40]

HI,

In addition to your previous steps.

Step 3:-
Use Loop through the Collection, Use your Output collection
Step 4:-
BO - Collection - Action:- Add Row
To add empty row to final collection
Step 5:-
Use Calc Stage
Replace([Output.Column1], ",", " ")
Write to Final Collection

 

[amlan Sahoo]

I have solved it completely,
PFB steps with attached screen shots,
Pre requisite:- Create a collection with required Field means the way you want to store in the collection(Refer the Screen shot Collect).
Action-1 "Calculation Stage" Replace ";" with ","
Action-2 "Utility-Strings" Split Text into Collection.
Action-3 "Utility-Collection and Manipulation" To Remove Empty Rows.
Action-4 "Loop Split collection" PFA for that.

Let Me know If still have any doubt.

I have attached screen shot for every thing please let me know still if you have any doubt will provide release file over here.