How to remove datatable data contains particular character and delete entire row using linq

Help
, , ,
1

If below column Description as “Invalid” then it should remove entire row using linq
image

Output:
2 America
5 Good Boy

1 Like
2

Hi @Aravinthan
Check this

dTable.AsEnumerable().Where(r(“Description”).ToString.Contains(“invalid”).CopyToDataTable()

Thanks
Ashwin S

3

Hi @Aravinthan

use delete data row

Thanks
Ashwin S

4

Hi @Aravinthan

After using read range use Filter datatable table activity and set rows filtering mode as remove and keep column name as “Description” and set operation as contains and value as Invalid and pass the output in write range

image
image969×446 18.6 KB

If you find it useful mark it as solution and close the thread.

cool,
Regards,
Gulshiyaa

5

Remove dataRows.xaml (8.7 KB)

@Aravinthan.

Thanks!

6

when Invalid is case sensitive how to handle if it coming in upper or lower case then it not removing kindly help

7

Hi @Aravinthan

try this

Thanks
Ashwin S

8

use or

image

one is in upper case and other one is lower case…

If you find it useful mark it as solution and close the thread.

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.