How to delete a column in CSV

HOw to delete a column from C:F in csv file?

I mean what is the activity i need to use. I used delete column but it is applicable only in excel scope.

Please help me on this

@vijai1, Read that CSV to a Datatable
Then use Remove DataColumn activity

Regards,
Dominic :slight_smile:

thank you

What if, i need to delete certain rows to get header, please advise…

@Ashik_Khan, not sure if I understand your requirement completely. If you wanna delete a few rows from the datatable, please use Remove DataRow activity. Also, there are many posts in the forum regarding the same. Example: Delete data row from data table

1 Like