Cannot parse the data from CSV file if there is an enter key pressed between two words in same cell

I am trying to parse the csv file using the following code
string[] EachColumnData = null;
EachColumnData = line.Replace("\",\"", "|").Replace(",,", "||").Replace("\"", "").Split('|');

But it doesnot work,if there is an enter key pressed in between two words of a column value, it would be splitted as new row . I have attached my sample csv format herewith. How can I fix my code to accept the data as a single record even if there is space or enter inside a column value.

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

karenpayneoregon · May 15 at 02:25 AM

If you want help, add a text file which can reproduce this issue. Have at least two problem lines and at least two good lines. Using a image is good for visuals but not to recommend a solution.

0 ·

PolachanPaily-6650 karenpayneoregon · May 15 at 06:03 AM

[202043-samplecsvtestfile.txt][1]

I have attached Text file also ,
[1]: /answers/storage/attachments/202043-samplecsvtestfile.txt

0 ·

samplecsvtestfile.txt (967 B)

karenpayneoregon PolachanPaily-6650 · May 15 at 07:46 AM

After reviewing the lines I would say the "z followed by a return is a one-off and not worth fixing in code. Instead read each line without splitting, check that the first character is 0-9 and if not flag it for manual processing.

Also it appears you made an effort to fix other issues (at least I see it that way), seems that you need to set the format and whomever is providing the file needs to adhere to the format or be rejected.

0 ·