Removing New line character in Fields PHP

Question

Hi,

i am trying to upload an excel file and to store its contents in the Mysql database.

i am having a problem in saving the contents.. like

My csv file is in the form of

        "1","aruna","IEEE 
         paper"
        "2","nisha","JOurnal magazine"

actually i am having 2 records and i am using the code

<?php
  $string = file_get_contents( $_FILES["file"]["tmp_name"] );
  //echo $string;

foreach ( explode( "\n", $string ) as $userString )

    {
                 echo $userString;

            }

?> since in the Csv record there is a new line inserted in between IEEE and paper it is dispaying me as 3 records..

How to remove this new line code wise and to modify the code so that only the new line between the records 1 and 2 is considered... Pls help me....

Answer 1

Maybe you should be using a library to open and modify excel files. Try with XLS Reader.

Answer 2

Use fgetcsv to load an parse CSV files.

Answer 3

The fgetcsv command is powerful and useful, you should probably use it. But if you want your original question answered...

1. replace the "good" newlines with some weird token, like @EOL@
2. replace the "bad" newlines with another token, like @NL@
3. replace the first token with a newline
4. parse your data.

like so...

<?php   
    $txt = <<<_TXT
"1","aruna","IEEE 
paper" "2","nisha","JOurnal magazine"
"2","aruna","IEEE paper" "2","nisha","JOurnal magazine"
"3","aruna","IEEE paper" "2","nisha","JOurnal
magazine"
"4","aruna","IEEE paper" "2","nisha","JOurnal magazine"
_TXT;
    $txt = str_replace("\"\n", "@EOL@", $txt);
    $txt = str_replace("\n", "@NL@", $txt);
    $txt = str_replace("@EOL@", "\n", $txt);
    echo $txt;
?>

The output is...

"1","aruna","IEEE @NL@paper" "2","nisha","JOurnal magazine

"2","aruna","IEEE paper" "2","nisha","JOurnal magazine

"3","aruna","IEEE paper" "2","nisha","JOurnal@NL@magazine

"4","aruna","IEEE paper" "2","nisha","JOurnal magazine"