How to delete the row in csv file based on criteria

Help
, ,
1

I have excel file and would like to keep those service=“Program” and Status=“Pending” and remove the the remaining row. Please assist. Thank you.

SR.xls (25.5 KB)

2

Hi,

Hope the following helps you.

img20200117-2

dt=dt.Select("[Service ]='Program' and [Status]='Pending'").CopyToDataTable

Regards,

1 Like
5

I thou i have sorted it out. But no. don know how to copy the result. but to the another file or same file .
Here is the script
del.zip (18.0 KB)

6

Hi,

Do you want to write it to a CSV file?
If so, you can use Write CSV activity to write it as the following image.

img20200120-1

Or, if you want to write to XSLX file, you can use Write Range Activity.

Regards,

7

It worked. Thank you friend.

1 Like