Selecting hyperlink from HTML table of web page

[lata]

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

[Naveen_tg (Naveen)]

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

[lata]

Hi,

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

[Naveen_tg (Naveen)]

@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.

[lata]

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

basically it does not give me exact URL

[Naveen_tg (Naveen)]

can you provide the link of web page?

[lata]

sure .

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

[nimin (nimzz)]

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’
Then choose the second date as second element in the same column.

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

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

And the final result will be like this.

I hope that’s your requirement.

Warm regards,
Nimin

[lata]

@nimin

irst and second element row wise.

Thanks @nimin.

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

[Naveen.Ch (NaWin)]

@lata yes,you can do

[lata]

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

[nimin (nimzz)]

Hi @lata,

May I know which browser are you using?

[lata]

Internet Explorer

[nimin (nimzz)]

Hi @lata,

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

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.

Warm regards,
Nimin

[lata]

Thank you very much for your help.It worked