CSV Reader to edit CSV files

Goldy · 14 Sep 2012 at 09:23

Hi,

Im trying to design and code an application to read a .csv file and take data out and relocate into other csv files.

What currently happens is that each day I receive a CSV file containing around 10 rows, each row containing around 100 values with the first number in that row being a unique reference. I simply want to go through each row and copy that row into its own new .csv file. So each row will eventually have its own file.

I plan on programming this in C# so i understand theres already some handy tools in place for reading and writing CSV files. Can anyone point me in the right direction on how to do this?

Thanks!

Goldy · 17 Sep 2012 at 09:10

Thanks all, i will try CSVHelper to start with.

Goldy · 23 Sep 2012 at 11:51

Bit of a noob question, how exactly do I use this parseCSV function?

I've declared the String path as the file location where the file is but not sure how I pass that to the function so it can start running through the rows.

Go to the full function half way down the page:
http://www.switchonthecode.com/tutorials/building-a-simple-csv-parser-in-csharp

Goldy · 23 Sep 2012 at 17:12

Thanks Pho, that sort of worked.

To cut to the chase, here is a sample of the .csv files im working with. This one has 4 rows. I want to go through each row and copy that row to a new file.

Sample file

Goldy · 23 Sep 2012 at 19:25

Thanks Eulogy. Although I know even less about using Powershell than I do with C#. I will also be including some FTP download and upload and file management functions around this part of the code. Im ok with these bits its just the part that processes the file that I need help with.

If I were to use the StreamReader class in C#, how do i make it read a set number of values before moving onto the next row. My rows will consistently be 101 values. All i can find now are ways of splitting rows by a comma or space which isnt much use.

Goldy · 4 Oct 2012 at 13:09

Thanks for the assistance guys. Visibleman hit the nail on the head, it was simply a case of reading the file line by line and delimiting the values by ','. Amazing how quick it can process thousands of lines and append the line to a new file.