Filter Datatable - Not like filter

datatable
excel
uiautomation
studio

#1

Hello Everyone,

Can anyone please help me with the syntax for “Like” operator in filtering a datatable

Couldn’t find in this forum as well. Moreover when I try it returns as a datarow but I want to have a datatable. Even if I try to declare the assign “To” variable as “DataTable”, I am getting an error message that Datarow cannot be converted to DataTable

Thanks
Selva


#2

Hi @Selvasathappan,

use below query

DataTable=DataTable.Select("ColumnName like '%Arivu%'").CopyToDataTable()

More related to datatable information

Regards,
Arivu


#3

Thanks dude. You are awesome.


#4

@arivu96, Any thoughts on below issue?


#5

@arivu96 - Can you please help me with this?


#6

@arivu96 - Can you please help e with this?