My problem is: I’m download an excel file with a column that I need to filter and save somewhere. I need to filter the data by predefined words however I know what words should NOT show.
So for example:
How can I set the automation that it shows for example: everything BESIDE E, F and G?
(From d In yourDT.AsEnumerable()
Where Not d(“yourColumnName”).ToString().Trim().ToUpper.Equals(“E”) Or Not d(“yourColumnName”).ToString().Trim().ToUpper.Equals(“F”) Or Not d(“yourColumnName”).ToString().Trim().ToUpper.Equals(“G”) Select r = d).CopyToDataTable()