https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91718#M41670 my result now is: Column1 last name, first name, email@mail.com last name2, first name2, mail2@mail.com last name3, first name3, email3@mail.com   But I Need it Column 1                  Column 2             Column 3 last Name                 first Name             email@mail.com   Mon, 15 Oct 2018 15:58:00 GMT MareenFlemming 2018-10-15T15:58:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91714#M41666 Hi guys, I need some help. In my Business case I have an Share Point list with different data. My process is reading the data and put it in a Collection. In one column I have text like this: last name, first name, email@mail.com; last name2, first name2, email2@mail.com; last name3, first name3, email3@mail.com; I need all this information in another collection to write this data in another step of the Business process. How can I extract this data from an collection to a second collection?   Thank you so much. Mareen Mon, 15 Oct 2018 12:58:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91714#M41666 MareenFlemming 2018-10-15T12:58:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91715#M41667 Use simple for loop - loop the collection you've got from Share Point, split each string by comma (each value is separated by comma), so you will end up with three separate string ""last name"", ""first name"", ""email@mail.com;"". Further process strings (remove excessive whitespaces or semicolon) a put them into separate fields in desired collection.   Hope this helps! Mon, 15 Oct 2018 13:48:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91715#M41667 MarekSimon 2018-10-15T13:48:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91716#M41668 If the two collections have the same structure than you can assign the whole collection using one Calc stage. Mon, 15 Oct 2018 14:54:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91716#M41668 John__Carter 2018-10-15T14:54:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91717#M41669 Hey, thanks for help. I tried it to work with BO Utility - Strings ""Split Text"" The text is splitted fine, but I Need it in columns not in rows. How can I manage this? Mon, 15 Oct 2018 15:49:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91717#M41669 MareenFlemming 2018-10-15T15:49:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91718#M41670 my result now is: Column1 last name, first name, email@mail.com last name2, first name2, mail2@mail.com last name3, first name3, email3@mail.com   But I Need it Column 1                  Column 2             Column 3 last Name                 first Name             email@mail.com   Mon, 15 Oct 2018 15:58:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91718#M41670 MareenFlemming 2018-10-15T15:58:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91719#M41671 Simply use Utility - Collection Manipulation, action Append Field (text), where you specify Collection to modify and name of the column as Field Name parameter. You can leave Value parameter empty - read the documentation for the action, if more information is needed. Mon, 15 Oct 2018 16:00:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91719#M41671 MarekSimon 2018-10-15T16:00:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91720#M41672 As for your latest reply with the expected output.. Apply the advice I gave you, i.e. split single input from the collection, using comma as delimiter. Example: ""last name, first name, email@mail.com"" should result in ""last name "", ""first name "", ""email@mail.com;"". Three separate strings. Remove whitespaces and semicolon. At this point, you have 3 separate strings. Now, add row to the final collection and simply store all three string into separate columns in the final collection. Mon, 15 Oct 2018 16:05:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91720#M41672 MarekSimon 2018-10-15T16:05:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91721#M41673 Hey,   Sorry I cannot follow your describtion. For me it is not so simply ;) I'm not sure what I have to do now. Should I use Collection Manupulation, Action ""Append Field (Text)? If yes, than I only get empty field in my Output. I understand the Point with rmove whitespaces and semicolon. But how can I add rows to the final Collection?   Sorry for my misunderstanding Mon, 15 Oct 2018 16:23:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91721#M41673 MareenFlemming 2018-10-15T16:23:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91722#M41674 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 is            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 Mon, 15 Oct 2018 16:41:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91722#M41674 MareenFlemming 2018-10-15T16:41:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91723#M41675 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. Mon, 15 Oct 2018 17:10:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91723#M41675 MareenFlemming 2018-10-15T17:10:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91724#M41676 Hi, here I send one solution Mon, 15 Oct 2018 17:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91724#M41676 MarekSimon 2018-10-15T17:40:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91725#M41677 Another solution. This is maybe easier for people not familiar with BP that much. This solution was suggested by my colleague. The idea is, that we replace SEMICOLON with new line feed, so we get comma separated values for each entry on separate row. Then you save the resulting string to a file, so the file looks like  last name, first name, email@mail.com  last name2, first name2, mail2@mail.com  last name3, first name3, email3@mail.com   Then, you can use Get CSV Text As Collection action from Utility - File Management object and load the file, ending up with nice collection you need. Mon, 15 Oct 2018 17:44:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91725#M41677 MarekSimon 2018-10-15T17:44:00Z https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91726#M41678 Wow, thank you so much. Mon, 15 Oct 2018 17:49:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-extract-text-in-a-column-field-from-a-collection-to/m-p/91726#M41678 MareenFlemming 2018-10-15T17:49:00Z