How to extract Status from website Table

How to extract Status And Pancard number from the table present in a website(http://botsdna.com/ActiveLoans/) based on last4digits on LoanCode

. Can anyone please help.

You can do something like this : (((From d in dt.Select Where d("LOAN CODE").ToString.EndsWith("7325") Select(d)).CopyToDataTable).Rows(0)(1)).ToString

1 Like

Hi @Sriram_Gatla

Use Data Scraping to extract the data from the website since its Structured!

Regards

1 Like

Hi,

There are duplicated LOAN CODE : CANARA BANK-8454 and KERALA GRAMIN BANK-8454 in the table.

How do you want to handle the above?

Regards,

Actually the use case is different.

find the below video that you can understand the use case clearly.

I was trying