Filter rows using not like

Help Studio
, , ,
1

How to filter dt columns that does not start with number 8…I tried filter table but getting 0 rows…number would be like"856543390".Also it. Says the column is of double type… How can I do this in linq ? Or any simple method

2

Can you tell what you have used in the filter datatable Activity before?
Can you share the screen shot

3

Hi,

How can I do this in linq ?

Can you try the following?

dt = dt.AsEnumerable.Where(Function(r) r("Column1").ToString.StartsWith("8")).CopyToDataTable()

Sample20210803-2.zip (2.5 KB)

Regards,

4

my condition here is “does not start with”

5

image
image742×183 6.03 KB

6

Hi,

How about the following?

dt = dt.AsEnumerable.Where(Function(r) not r("Column1").ToString.StartsWith("8")).CopyToDataTable()

Regards,

1 Like
7

You have asked for does not starts with “8”
In screenshot it is “1”? Whether you need this condition also ?

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.