How to extract Status from website Table

How to extract Status And Pancard number from the table present in a website( 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!


1 Like


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

How do you want to handle the above?


Actually the use case is different.

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

I was trying