Filter datatable on value not starts with values in an array of string

Help Studio
1

I have a string with say 20 productheaders, separated with a comma (arrayProductheaders)
I want to filter a datatable to result in only the rows where the product does not start with one of the product headers

to include the header i use:
dtClientProducten.AsEnumerable.Where(Function(r) arrayProductheaders.Split(","c).Any(Function(x) r(“Product”).ToString.ToUpper.StartsWith(x))).CopyToDataTable
This works like a charm.

to exclude I thought to use
dtClientProducten.AsEnumerable.Where(Function(r) arrayProductheaders.Split(","c).Any(Function(x) not r(“Product”).ToString.ToUpper.StartsWith(x))).CopyToDataTable
This does not give met the result i want.
What am i missing, or how to better this?

2

Hey @Luke69,

Try this:

dtClientProducten.AsEnumerable.Where(Function(r) arrayProductheaders.Split(","c).All(Function(x) not r(“Product”).ToString.ToUpper.StartsWith(x))).CopyToDataTable

used .All instead of .Any as you don’t want item that does not start with any (means all) product headers

3

and so simple in can be. thanks for that. This works.