help with inport csv file to my C# program

Question

i try to inport csv file to my database in my C# winform program.

for example the csv file:

code  ,name    ,price
101010,computer,200$

and i done this:

char[] BI = { ',' };
string[] WI = TEMP.Split(BI);
A = WI[0].Trim().ToString();
B = WI[1].Trim().ToString();
C = WI[2].Trim().ToString();

but what i can do if the name contain (,) ?

for example

code  ,name              ,price
101010,computer 12,200.00,200$

if i get this type of csv:

code    ,name                ,price
"101010","computer 12,200.00","200$"

how to deal with this ?

Scott Chamberlain · Accepted Answer · 2010-12-14 19:28:15Z

8

The best thing to do is not roll your own csv and use a existing free library. I recommend FileHelpers.

EDIT:

Here is a fun little read, I bet you are on step 2 or step 3.

edited Dec 14, 2010 at 19:28

answered Dec 14, 2010 at 19:22

Scott Chamberlain

128k37 gold badges299 silver badges447 bronze badges

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

Comments

L-Four · Accepted Answer · 2010-12-14 19:29:16Z

5

Have a look at http://www.codeproject.com/KB/database/CsvReader.aspx, I believe this solves your problem.

answered Dec 14, 2010 at 19:29

L-Four

13.6k9 gold badges73 silver badges116 bronze badges

3 Comments

Scott Chamberlain Over a year ago

I use CsvReader when Filehelpers has issues.

he_the_great Over a year ago

@Scott, what issue would those be, and wouldn't it be best to report them to the author?

Scott Chamberlain Over a year ago

@he_the_great I had some issues with non printable characters in the csv (caused from a export from a corrupted database) i was importing. CSVReader was simpler to dive in to and edit so i could break on the bad lines and skip over them

Collectives™ on Stack Overflow

help with inport csv file to my C# program

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related