Screen Scraping HTML table is not as expected

studio

#1

Hi all

I’m getting a text from an HTML table with Screen Scraping Tool and it gets the text but I don’t know how to edit the text as I want. I mean I’m getting something like this:
"1/2/19.66293/19.48994/19.37175/19.24276/7/8/19.2737"
But what I want is a text with the following format to be inserted in a DataBase with For Each Activity:

Column1 Column2
1
2 19.6629
3 19.4899
4 19.3717
5 19.2427
6
7
8 19.2737

How can I do this?

Regards
J.


#2

Hi @Juramirez,

If you have html table structure use data scraping to extract the data as Datatable.

Regared,
Arivu


#3

Thanks for your reponse but I did that and is not working. The table i’m scraping is like this:

Column1 Column2 Column3 Column4 Column5
1/ 2/19.6629 3/19.4899 4/19.3717 5/19.2427
6/ 7/ 8/19.2737 9/ 10/

And I want something like:

Column1 Column2
1
2 19.6629
3 19.4899
4 19.3717
5 19.2427
6
7
8 19.2737

because with this I can use for each activity and send each row to DataBase.
Any help is appreciated.

Regards
J.


#4

Hi @Juramirez,

try to use while scraping ->Get Word Info -> custom separator
In custom separator try to give these values and check(\n or give one space or tab(\t))

after that you can split the data to datatable as per your requirement.

Regards,
Arivu


#5

Hi @arivu96

Can you provide an example? I did what you said and can’t get what I need.

Regards,
J.


#6

Hi @Juramirez,

Use custom separator to get formatted string, from this string you need to convert it again as data table.

Refer below url

Regards,
Arivu


#7

Hi @arivu96

I tried it but I can’t get what I want. Any other option? Something with For Each child may work? I don’t know what else can I do to achieve what I want.

Regards,
J.