Mareenchen
New Member
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.
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.