Find keyword inside excel

GoodMorning,

I have a problem i can’t to make work the Function SELECT.
My problem is: i need to find specific word (keyboard) inside a text from column, the keyboard is OK. The column name is Desc
E.g. I use this Dt_Result.Select("(Desc)=‘OK’")

Thank you very much
Please help
Regards

This is my file
KEyboard.zip (16.6 KB)

Dt_Result.Select("Desc=‘OK’") or Dt_Result.Select("[Desc]=‘OK’")

1 Like

Hi, thank you
@KarthikByggari

Don’t work, because i use read column so they give me a error when i use assign, and i don’t know why
Thanks

Can I know the error message?

Hello,

You can refer the following program, once you use select statement you should use looping for accessing the data of the filtered column.

Main.xaml (10.0 KB)

1 Like

@KarthikByggari
goodmorning,

i found a different solution so thanks thousand to both for the help.
have a good day