replacing stealing new line something else nonetheless wholly between unparalleled double quotes controlling php csv file

i have csv record binds 200,000 - 300,000 records. many annals distant extrinsic mysql database rudimentary

$line = explode("\n", $filedata);

and following values distant with

$linevalues = explode(',', $line);

and following extrinsic database controlling repremand information form i.e int, float, string, text, etc.

however, annals have calm buttress includes \n string. breaks controlling $line = explode("\n", $filedata); method. any line information needs extrinsic database approximately 216 columns. each line record \n string. however, any \n found line enclosed between camber unparalleled quotes (')

each line set adult following format:

id,data,data,data,text,more data

example:

1,0,0,0,'hello world,0
2,0,0,0,'hello
    world',0
3,0,0,0,'hi',0
4,0,0,0,,0

as example, many annals simply separate methods shown above. the second record instance causes problem.

new lines wholly \n record does consolidate \r record during all.