I’d like to filter the row if the cell contents contains various value.
Is it possible to filter like this? Please refer to below example.
Current status is I can filter with specific keyword with below script! (Had some helps from this forum :))
(from x as DataRow in Dt2_HSBC_001 where x(“Name”).ToString.Contains(“Joy”) select x ).CopyToDataTable
The problem is key words are multiple like below(Iist is stored in excel file)
So, If target row contains one of key word among this excel list, I’d like to remain.
- validate with ‘keyword excel file’ whether the row contains keyword or not
- Only remains the rows which contains keywords.
It’s a bit complicated,so please let me know if you need further information !
Thank you for helps always !!