How can we delete/remove blank rows from a csv file without loading it in memory in C#?

Question

I have a csv file which may have empty or blank rows. I want to delete such rows but the problem is that the csv files can be potentially very large. So, I am looking for a way to do it without having to load it in memory.

The solution that works for me is using a DataTable or a StreamReader, but both of them will be using the memory which is not preferable.

Thanks in advance.

Using a StreamReader, you don't have to load the whole file into memory at once - you can do it line-by-line. — Rawling
– Rawling, Commented Jun 20, 2012 at 7:46

Marcos Meli · Accepted Answer · 2015-08-03 14:21:21Z

4

I don't think you can do it without loading the file.

I would use a fast CSV reader/writer from http://www.filehelpers.net - I'm sure you can link writer stream to reader stream so you write as you read and you don't need to load the whole file at once.

edited Aug 3, 2015 at 14:21

Marcos Meli

3,50627 silver badges29 bronze badges

answered Jun 20, 2012 at 7:35

Jakub Konecki

46.1k8 gold badges92 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can we delete/remove blank rows from a csv file without loading it in memory in C#?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related