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.
Can you send those lines as a text here?
Can you try the following expression?
Checkout this expression
String Variable = System.Text.RegularExpressions.Regex.Match(variable1,“(?<=stars\n)Cooking.\n.”).ToString
After getting the value you can add them in the Add datarow activity in order to add them in the datatable and in the excel like this
Resturant Equipment.xaml (23.0 KB)
Thanks for the response. I attached my xaml file for your reference. Please see once i run this and i recieved all the detail in message box.
I want only Title in Excel file then this title i want to use to search this product on the same page where i get this title from. Then i want to open this product page in new tab and extract Price, UPC Code, and diffrerent prices in bulk QTY.
Could you please check this Xaml file and provide me sequence and assign activities to solve this issue.
For now, can you try the following expression? This can extract title in each item.
System.Text.RegularExpressions.Regex.Match(CurrentRow(0).ToString,"(?<=(NATURAL GAS|LIQUID PROPANE)\r?\n(Rated.*\n)?)(?!Rated)[\s\S]+?(?=\r?\n\r?\n)").Value
Thanks its working properly.
I want to write this title on excel file. what is the next step i need to use after this activity.
Hope the following helps you.
Resturant Equipment.xaml (15.6 KB)
Thanks for the solution.
Please see the attached Picture i am using the extract data table and i am selecting the next page “>” but its not working. Once i am running the project its stop on the first page and extract data only 1 page. Target and selectors which i am selecting its ok. But where is the exact mistake i am not find it out.
May be you didn’t change the count of the rows as 0
If not change to zero and run the process again