How to filter datatable only use one column contains part of the value

[sarah]

how to filter datatable only use one column contains part of the value

[vvaidya (Vinay Vaidya)]

dt.Select(“ColName Like ‘%abc%’”)

[sarah]

thanks

[abdel (Robot usa)]

YHead.Select(“Column24 Like #’”) throuw following error:
Assign : The expression contains an invalid string constant: '#’.

[mario]

Hello all,

is there an opposite command? “notLike” does not seem to be working.

Thx

[aksh1yadav (AKSHAY YADAV)]

Hey @mario

@mario

Hello all,

is there an opposite command? “notLike” does not seem to be working.

Thx

It works just you have to use it with space

Sample for your understanding - Datatable select with Not like.xaml (8.0 KB)

Note:- To be More honest if you dont aware with the syntax being newbie i will advice to all use New Filter Datatable Activity with Human Intractable User Interface

Regards…!!
Aksh

[venkatesh_singamsitt (Venkatesh Singamsitty)]

can you send me your personal email id to my email venkatesh.sitty@gmail.com

[Gabriel_Tatu]

Are you guys using 18.2? We have some new datatable activities that you can use.