Importing csv values having multiple comma in one column in Asp.net

Question

I am having an issue with importing a CSV file. The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc.

I tried to use http://forums.asp.net/t/1705264.aspx/1 this article but, the problem did not solved because of a single field containing multiple comma separated values.

Any idea or solution? because I didnt found any help

Thanks

If your using that solution then I'd recommend looking at how you can change what splits the lines up and hope that theres a difference between the address and the separator character — Sayse
– Sayse, Commented May 2, 2013 at 17:51
This is a common ETL issue, can the provider either change the delimiter or wrap the strings in double quotes? — Mark Kram
– Mark Kram, Commented May 2, 2013 at 17:55

joshgo · Accepted Answer · 2013-05-02 17:57:58Z

2

Don't split the string yourself. Parsing CSV files is not trivial, and using str.Split(',') will give you a lot of headaches. Try using a more robust library like CsvHelper - https://github.com/JoshClose/CsvHelper

If that doesn't work then the format of the file is probably incorrect. Check to make sure the text fields are properly quoted.

answered May 2, 2013 at 17:57

joshgo

1,1931 gold badge9 silver badges14 bronze badges

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

Comments

Devin Goble · Accepted Answer · 2013-05-02 17:54:19Z

0

Do you control the format of the CSV file? You could see about changing it to qualify the values by surrounding them with double quotes (""). Another option is to switch to a different delimiter like tabs.

Barring that, if the address is always in the same format, you could read in the file, and then inspect each record and manually concatenate columns 2, 3, and 4.

answered May 2, 2013 at 17:54

Devin Goble

2,9374 gold badges33 silver badges46 bronze badges

2 Comments

Devin Goble Over a year ago

What about the second option? Just treat those extra commas like they are valid column delimiters and piece things together at another stage.

skhurams Over a year ago

csvhelper is perfect for me. I have not made csv files if i created it i could try second option

Jeff Maner · Accepted Answer · 2013-05-02 18:05:15Z

0

Are the fields surrounded by quotation marks? If so, split on "," rather than just ,.

Is the address field at the beginning or end of a record? If so, you can ignore the first x commas (if at the beginning) or split only the correct number of fields (if at the end).

Ideally, if you have control of the source file's creation, you would change the delimiter of either the address sub-fields, or the record fields.

answered May 2, 2013 at 18:05

Jeff Maner

1,1792 gold badges9 silver badges24 bronze badges

Collectives™ on Stack Overflow

Importing csv values having multiple comma in one column in Asp.net

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related