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

Polachan Paily 91

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.

Karen Payne MVP 35,036 Reputation points

2022-05-15T02:25:34.05+00:00

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.
Polachan Paily 91 Reputation points

2022-05-15T06:03:32.817+00:00

202043-samplecsvtestfile.txt

I have attached Text file also ,
Karen Payne MVP 35,036 Reputation points

2022-05-15T07:46:07.65+00:00

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.