Clearing CSV fie

Hi I have an existing CSV with list of data.

My question is how can I clear the data without removing the column names?

Thank you!

Hi alvin,

Possible step:

  1. Read CSV - Add to datatable
  2. Clear Datatable
  3. Write CSV - input datatable
1 Like

Hi, you can read it into a datatable (make sure IncludeColumnNames is ticked), clear the datatable then write back to the CSV (make sure AddHeaders is ticked). Hope that helps.

1 Like