I have row which is coming from csv file like
"abc@example.com","seattle,US","9999 00000"
Expected Output:
abc@example.com
seattle,US
9999 00000
Actual output when I do string.Split(','):
"abc@example.com"
"seattle
US"
"9999 00000"
Asked
Active
Viewed 928 times
-1
Tim Schmelter
- 450,073
- 74
- 686
- 939
Saurabh Verma
- 49
- 5
-
1Show what you have done – Tim Schmelter Sep 16 '16 at 10:31
-
Use a real csv parser not string.split – Tim Schmelter Sep 16 '16 at 10:32
-
The `split` can not understand what you have on your mind - is work correctly for your output - if you need something different, just code it. – Aristos Sep 16 '16 at 10:33
-
`using (var parser = new TextFieldParser("path")) { parser.HasFieldsEnclosedInQuotes = true; parser.Delimiters = new[] { "," }; while (parser.PeekChars(1) != null) { string[] rowFields = parser.ReadFields(); } }` – Tim Schmelter Sep 16 '16 at 10:36
-
by the way - in the duplicate marked question aren't text qualifiers `"` – fubo Sep 16 '16 at 10:38
1 Answers
0
If you use " character to qualify a column, you can split by ","
string input = "\"abc@example.com\",\"seattle,US\",\"9999 00000\"";
string[] result = input.Trim('"').Split(new string[] { "\",\"" }, StringSplitOptions.None);
fubo
- 44,811
- 17
- 103
- 137
-
Haven't downvoted. But this is not a very good approach. The delimiter is clearly a comma not the quotes. Your workaround works in this case though – Tim Schmelter Sep 16 '16 at 10:39
-
@TimSchmelter but the quotes are even existing if there are no commas within their content – fubo Sep 16 '16 at 10:42
-
1If every field in every line is surrounded by quotes, the splitting on "," seems fine to me. What's wrong with this answer? – Michael Gorsich Sep 16 '16 at 10:49