Converting data to csv format using C#. ?

Question

0.00/5 (No votes)

See more:

Hi all

I have a couple of questions relating to my subject line.

How would I convert data in a text file, or even directly from say, a list buffer, to csv format? What class/functions/properties would come in handy? Can anyone maybe give me a function example?

Thanks,

Posted 15-Nov-10 22:48pm

R. Erasmus

Updated 15-Nov-10 22:50pm

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Laurence1234 · Accepted Answer · 2010-11-15T23:27:00

Hi there RudolfErasmum,

The String class will have handy functions like 'String.Split', as to create a CSV you will need to delimit your original text by a predetermined
character.

After you have split down your text the StringBuilder class will be a handy to rebuild your strings inserting a comma where required. A method that I would suggest using is Append.

It might help then to take a look at the StreamWriter class, to save your memory stream to a CSV file.

MSDN has a lot of information relating to these classes and the related methods.

Hope that helps.

Larrythemule

**JF2015** · Accepted Answer · 2010-11-15T23:05:00

Solution 1

Hi,

there are lots of articles on Codeproject that cover this topic. Here are some I found:

http://www.codeproject.com/KB/database/Cs_CSV_import_export.aspx[^]

http://www.codeproject.com/KB/database/filehelpers.aspx[^]

http://www.codeproject.com/KB/cs/CsvReaderAndWriter.aspx[^]

Posted 15-Nov-10 23:05pm

JF2015

Comments

Dalek Dave 16-Nov-10 5:09am

Good Links

R. Erasmus 16-Nov-10 5:12am

I've had a look at the links you send me and it is of great help, thx.

ARopo · Accepted Answer · 2010-11-15T23:07:00

Solution 2

Read and writing file look at
System.IO area StringReader/StringWriter

manipulating strings:

StringBulder to build up lines

to read in

string[] fields = string.Split(',');

Posted 15-Nov-10 23:07pm

ARopo

Updated 15-Nov-10 23:23pm

v2

Comments

R. Erasmus 16-Nov-10 5:13am

I was looking for something more specific and less work, thx :)

Richard MacCutchan · Accepted Answer · 2010-11-15T23:12:00

Solution 3

CSV files are just text files whose content is made up of lines of text. Within each line of text fields are separated by commas. Thus all you need to do is to create a file with the .csv extension, and write your data to it. See here[^] for a sample that you could modify to your requirements.

Posted 15-Nov-10 23:12pm

Richard MacCutchan

Comments

Dalek Dave 16-Nov-10 5:14am

Good point.

R. Erasmus 16-Nov-10 5:21am

Your answer was noted.