How to parse the table is this page?

UI.Vision RPA General Discussion
1

Hi,

I need help to parse the table on this page:

I want to be able to fetch and store the values in every cell.

The number of rows can vary from 1, 2 to 6 rows.

I only need to save the name of the Buyer and the Price in variables. Name1, Name2, Name3… and Price1, Price2, Price3…

Any help will be much appreciated

2

Very difficult with ui vision because for storing is not the best solution

Ui vision whrn do not find a value skip the colums and have not a relative extration.

The best solution is imacros for firefox 8.9.7 with relative extraction.

3

I’d like to stick to UI.Vision

4

You can use:
storeText | //tr[2]//td[1] | Name1
storeText | //tr[2]//td[3] | Price1
Just change the tr[2] which is row #1 to a tr[3] which is for row #2, etc.
https://ui.vision/rpa/docs/selenium-ide/storetext

Or how about putting it into csv?
https://ui.vision/rpa/docs/selenium-ide/csvsave

1 Like
5

thanks a lot, how to do this as code?

6

Got it and it worked perfect, thank you :slight_smile:

{
“Name”: “Parsing prices from table”,
“CreationDate”: “2019-11-29”,
“Commands”: [
{
“Command”: “open”,
“Target”: “Buy bitcoins online in Norway with National bank transfer - LocalBitcoins”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “xpath=/html/body/div[1]/table/tbody/tr[1]/th[1]”,
“Value”: “”
},
{
“Command”: “storeText”,
“Target”: “//tr[2]//td[1]”,
“Value”: “Name1”
},
{
“Command”: “storeText”,
“Target”: “//tr[2]//td[3]”,
“Value”: “Price1”
}
]
}