Hello Everyone, Can someone help me out i want to manipulate data in from text file and put in the excel file with column names. As you can see in attached screenshot. i need to Tile strting from (Cooking) and end in BTU. So how can i Manipulate only title from here and write in Excel Sheet. [ima…

Data Manipulation Issue

Yoichi (Yoichi) October 8, 2022, 10:32am 3

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Rated.*\n)[\s\S]+?(?=\r?\n\r?\n)").Value

Regards,

Topic		Replies	Views
Excel Data Manipulation Advice Help studio	22	3022	January 24, 2020
Data manipulation on excel Studio excel , activities , data_manipulation	1	1316	March 6, 2021
Help with String manipulation - need to remove part of the string Activities excel , activities , studio , question	8	897	December 23, 2023
Using Regex to edit datatable values Studio datatable , studio , variable , regex , string , question , activities_panel	3	998	January 16, 2023
How can i extract only string from column A and write to columnB? Studio studio , question , activities_panel	6	649	July 26, 2023