Selecting a value from data table

datatable
datascraping

#1

Hi,
i am using uipath to scrape a HTML table and store it in a datatable. the actual table is really huge but the attribute reamin the same, only the values changes. i am trying to get a value from the table for the value adjacent to ‘pt_id’ – (output should be pt_567). for better understanding i have attached a example below.

i tried the below steps to find this
drow[] = dt.Select(“attribute = ‘pt_id’”)

but i am not able to see the results from the datarow.

currently the output show as ‘System.Data.DataRow’.
Please assist!!

sample.xlsx (8.2 KB)
Sample.xaml (7.1 KB)

image|673x431


#2

Hi,

Please try below code. Have tried it, it works.

drow(0).Item(“attr1”).ToString +"|"+drow(0).Item(“attribute”).ToString+"|"+drow(0).Item(“value”).ToString

Regards,

Umesh


#3

Thank you so much! Exactly what i wanted.