Filter Data Table. How to Get only JPG and PNG from Data Table and also i want to exclude some string in JPG. How to do that

[Puneet_Singh]

Column Name is New Column 0

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Puneet_Singh please show me datatable or excel. And eloborate what you want to do

[Puneet_Singh]

[Puneet_Singh]

In this i want to exclude Docs, excel and Signed Name JPG and some more text JPG.

[Yoichi]

HI,

Can you try the following?

excludeWords = {"waste","fuel","battery"}
validExts = {".jpg",".png"}

Then

dtResult = dt.AsEnumerable.Where(Function(r) validExts.Contains(System.IO.Path.GetExtension(r(0).ToString).ToLower) AndAlso (not excludeWords.Any(Function(s) r(0).ToString.ToLower.Contains(s)))).CopyToDataTable()

Regards,