Selecting hyperlink from HTML table of web page

HI,

i have 9 pages of HTML table of a single website,I have to select first and second column of that HTML table.1st column contains normal entry and 2nd column contains company name and hyperlink on it.

I want 1st and 2nd column with company name and along with its hyperlink stored in data table or in nay other source.Can anyone please advise me on this.

You help is much appreciated!

Many Thanks in adnvanced,
Lata

1 Like

@lata ,
Use data scrapping ,you can extract data from all 9 pages at once.

1 Like

Hi,

but it does not gives hyperlink along with that.see the attachement

1 Like

@lata,
while data scraping the column , data scrapping tool will ask whether you want to extract url with it or not select that option , the url behind it will be extracted.q

1 Like

if i use data scraping with option Extract URL then it gives me reslut like this

basically it does not give me exact URL

1 Like

can you provide the link of web page?

1 Like

sure .

https://www.fda.gov/ICECI/EnforcementActions/WarningLetters/2018/default.htm

1 Like

Hi @lata,

From your screenshot, it seems that you are selecting the first and second element row wise. That’s why you are getting incorrect results.
Choose the first date as ‘First element’1column
Then choose the second date as second element in the same column.col2

Then select the correlated data, that is company name in the same way.

corelated2

Select the “Extract URL” option in the extract wizard.


And the final result will be like this.

I hope that’s your requirement.:slightly_smiling_face:

Warm regards,
Nimin

1 Like

Thanks @nimin.

Can i select all 5 columns along with Extract URL option ?

1 Like

@lata yes,you can do

1 Like

I am getting such blank column when i select “Extract URL” option

1 Like

Hi @lata,

May I know which browser are you using?

1 Like

Internet Explorer

1 Like

Hi @lata,

You are getting a blank URL field may be because, you are selecting the entire cell sel2 instead of the hyperlink text sel1

Also, the URL of your website returns only the relative path. You can use the workflow FDA_DataScraping.xaml (11.4 KB) for getting all the data in tables including the absolute URL path.:grinning:

Warm regards,
Nimin

2 Likes

Thank you very much for your help.It worked :slight_smile:

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.