https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62249#M15401 Split text by line and then loop and then add text together. Mon, 11 Sep 2017 12:22:00 GMT Christer_Tellefsen 2017-09-11T12:22:00Z https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62247#M15399 Hello, I was hoping for a bit of assistance. I am trying to manipulate some data. I get text and store it into a data item. It looks like so: -------------------------- 2 September 2017. Dated 19 August 2017 19 August 2017 --------------------------- I am trying to combine/join the first 2 lines so it looks like (2 September 2017) and delete the other 2 lines. All 4 lines are variable in value (always dates as text), and so I cannot simply remove the above text with replace function. I am sure there would be a visual basic/.net code that can achieve this outcome, however lack the knowledge myself. Regards Andrew Mon, 11 Sep 2017 04:54:00 GMT https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62247#M15399 andrew_doman 2017-09-11T04:54:00Z https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62248#M15400 I have at least gotten rid of lines 3 and 4 with an instring looking for the ""."" and then obtained left -1 of that instring number value. Now just need to combine lines 1 and 2 with space between both lines (2 September 2017). I've heard there should be a regex utility available however in the development environment instance of BP I am working with it doesn't seem to be present. Mon, 11 Sep 2017 05:42:00 GMT https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62248#M15400 andrew_doman 2017-09-11T05:42:00Z https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62249#M15401 Split text by line and then loop and then add text together. Mon, 11 Sep 2017 12:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62249#M15401 Christer_Tellefsen 2017-09-11T12:22:00Z https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62250#M15402 No need to use regex or code stage to solve this. Use a multi calculation stage with the following expressions (""Data"" is the name of the data item): Left([Data], InStr([Data], ""."")) and store result in Data - this removes line 3 and 4 Replace([Data], NewLine(), "" "") and store result in Data - the replaces the new line with a space Mon, 11 Sep 2017 12:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Code-stage-Utility-that-can-combine-first-2-lines-and-delete-3rd/m-p/62250#M15402 OlaNykvist 2017-09-11T12:30:00Z