How to get particular row

datatable

#1

The string looks like this, (Weekly/MonthlyFile) Jun 2018
Thus if, the row has (Weekly/MonthlyFile) ‘and any other words’, get that row value.
I tried:

row(1).ToString().Contains(“Weekly/MonthlyFile”)
row(1).ToString.Select("Date LIKE %(Weekly/MonthlyFile)% “)
Dt.Select(” Date = * (Weekly/MonthlyFile) * " )

But it doesn’t work. Pls do guide how to go about with this
Main (7).xaml (7.8 KB)

Thank you xoxo


#2

Dt.Select("Date like '%(Weekly/MonthlyFile)%'").CopyToDataTable()

Regards,
Arivu


#3

It’s not working though


#4

Try * instead of % for the wildcards. It should work then


#5

@loginerror It works now. Thank you


#6