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


#1

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


#2

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


#3

thanks


#4

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


#5

Hello all,

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

Thx


#6

Hey @mario

It works :slight_smile: just you have to use it with space :slight_smile:

Sample for your understanding :wink: - 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 :slight_smile:

Regards…!!
Aksh


#7

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


#8

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