https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72936#M25541 You can use ""Split Text"" action of Utility-Strings with the split character as "" "" (meaning space) and then you can do""Remove Empty Rows""  action of Utility-Collection Manipulation. Thu, 30 Aug 2018 16:45:00 GMT SanjanaS1 2018-08-30T16:45:00Z https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72932#M25537 Hello   I have a text string that is returned from the application that looks like this. What is the best way to manipulate the text string to break it apart and store individual pieces in a collection that has First name, last name and account id. I use the clipboard to get this data back from the surface automation training. I think there is a space in the string between first and last name and a tab between last name and the account id. Help appreciated with best practices to do this using existing functionality. Gregory Williams          67036802652212 Thanks in advance   Mon, 27 Aug 2018 19:35:00 GMT https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72932#M25537 CR 2018-08-27T19:35:00Z https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72933#M25538 you can use trim function for remove space. Tue, 28 Aug 2018 05:54:00 GMT https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72933#M25538 akhileshshukla 2018-08-28T05:54:00Z https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72934#M25539 You can pick a calculation stage and then use the text functions left, mid and right. Wed, 29 Aug 2018 22:53:00 GMT https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72934#M25539 Roberto_Claudio 2018-08-29T22:53:00Z https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72935#M25540 You can replace space with comma (,) and then use Utility-String objects action CSV to Collection. I hope it will help you. Thu, 30 Aug 2018 13:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72935#M25540 SachinJagdale 2018-08-30T13:17:00Z https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72936#M25541 You can use ""Split Text"" action of Utility-Strings with the split character as "" "" (meaning space) and then you can do""Remove Empty Rows""  action of Utility-Collection Manipulation. Thu, 30 Aug 2018 16:45:00 GMT https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72936#M25541 SanjanaS1 2018-08-30T16:45:00Z https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72937#M25542 Thanks for all the help. The string is little more complicated than just two pieces of data. Some fields are separated by a space and others tabs. Also the space between the date and time and AM/PM is legit so the last field needs to stay intact.  Help is appreciated. *R*    SMITH                  Active              Person                       12/18/2006 12:09:00 PM  ELLI  B   SMITH             Active               Person                       12/18/2006 12:09:00 PM  Thanks all   Thu, 06 Sep 2018 01:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Text-to-collection-translation/m-p/72937#M25542 CR 2018-09-06T01:17:00Z