How to parse the table is this page?

Hi,

I need help to parse the table on this page:

https://localbitcoins.com/buy-bitcoins-online/no/norway/national-bank-transfer/

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

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.

I’d like to stick to UI.Vision

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

thanks a lot, how to do this as code?

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

{
“Name”: “Parsing prices from table”,
“CreationDate”: “2019-11-29”,
“Commands”: [
{
“Command”: “open”,
“Target”: “https://localbitcoins.com/buy-bitcoins-online/no/norway/national-bank-transfer/”,
“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”
}
]
}