as per this data, you will get this data in a tabluar format and you can use data scraping to get the entire table data. Then you can simply write the required info to excel using write range activity and the data as extracteddatatable.Rows(“Name”)
MayI know where you are trying to click? @Manohar1,
if it is on the data column name, then it seems the data is not in the tabular format, then we need to think of an alternative
Hello @Manohar1 .
Will this process be repeated few times? If yes, could you share similar example, maybe we could use some type of Regex to search for the name, then putting String Array into Data Table is easy
Okay… If you have the columns names same everytime, here are the few steps to follow :
Save the entire string in a variable and split it with first column name
As the data is with a new line character, use write csv activity to write the structured data to a CSV file and it will be easy. Use the seperator as NewLine character
Then read the CSV and get the required data from the data table using column headings
Here you go friend, you can use this with any file of yours (don’t have to be the specific date) .
The solutions above might be right for this case, but in the future, where your date changes you can use the example that i send to you.