The column has a value as TUGA - Utilities / Gas / Gas , The word Utilities is what I want to apply filter to and other columns as well but I am stuck at first column itself
If you are directly looking for the value ‘Utilities’ you can use the method mentioned by @anil5. However, if your string contains more info than the word ‘Utilities’ you can use the Like method like this
DT.Select("Industry like '%Utilities%").CopyToDataTable()
or
DT.Select("[Industry] like '%Utilities%'").CopyToDataTable()
I have a column Name : [Opportunity Name] and I want to keep rows which do not have words like ( Pragma, ARM, Infra, Security, Cyber, Finance, Banking) What can be passed so it discards rows that have any word from this array ?