How to get particular row

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.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

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


1 Like

It’s not working though

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

@loginerror It works now. Thank you