Extract unstructured Html datatable

[Pratiksha_Mahajan]

Please kindly help me with approaches for How to extract an unstructured Html data table from a chrome web browser?

Thanks in advance.

[Gokul001 (Gokul Balaji)]

Hi @Pratiksha_Mahajan

Have an view on the thread

Scrapping unstructured data from a single web page

You should use the Find Children activity and filter on items which match selectors related to a ‘message’. Then loop on each child and grab the aaname attribute. You can append each to a file. This outputs to a text file but should give you the basics of what you need. Main.xaml (9.6 KB) [messages]

Regards
Gokul

[shreyash_shirbhate]

@ppr , Can you please help on this?

We have gone through below post of yours but we are not able to find the solution.

[HowTo] Data Scraping - Advanced Configuration - Text Field, Image Source, Url, CSS Classname, Hover text

This HowTo introduces on how Data scraping can be configured to retrieve also on non standard information from a web table. After indicating the different data columns with the wizard the extract data definition was post edited and changed to the relevant attributes e.g. value (Text field), src ( Image Source), class (CSS Class Name), tite (Hover Text), href (Url). Introduction Following web table is to use for data scraping and also the non text information should be retrieved. [grafik] We…

In our case, we have many multiple data table which we need to extract. The code which we built on one of the data table where the data rows are 9, but when the bot is running and the data table is having more than 9 rows then it is not able to extract the data table properly.

Here I think we need to do the XML dynamic!!

[ppr (Peter Preuss)]

@Pratiksha_Mahajan

extract an unstructured Html data table

may we ask you to share some more details/samples on it? Especially to get a better understanding of what is meant with unstructured in detail.

In general we had made good experience with

• find children and processing the returned children
• XML Processing

For the last we should keep in mind, that HTML can conflict withXML Api, when e.g. elements are present which are not XML conform (<br>, not closing the empty tag). But depending on the cases we did overcome such things as well e.g. with text replacements to make them conform

[shreyash_shirbhate]

@ppr

unstructured in detail

@ppr Unstructured html in the sense we are not able to capture it using the Data extraction window in UiPath. It is giving us the wrong output.

Let me add you in one of my thread. You will have the more details on the same.

Also, @Pratiksha_Mahajan is my teammate. We both are working on this.

Thanks in Advance.