在php中替换 换行符

Question

I've written a small bit of php which gets items (products in this case) from an xml feed. I use simplexml_load_file to assign the various parts of the feed to variables.

It's working great and I'm outputting the results to a csv file. The problem I have is that some of the items in the xml are html descriptions and have line feed characters in them. This is breaking the csv as it sees these as new lines.

To solve this I've added an end of line string to each line of the csv and I'm trying to strip out all from the descriptions, then replacing the eol string with a which should make the csv work.

I can do it manually with notepad++ but when trying it with php it doesnt seem to work.

Below is the code I've tried but I might have messed something up as I've never done this before, and it doesn't seem to be working. The resulting csv still has the original line feeds and the eol string is still there.

//Get The Short and Long Descriptions from the $_item in the XML
   $short_Description = $_item->short_description;
   $description = $_item->description;

//OK now we need to firstly remove all the 
 
  from the descriptions and once that's done replace "FEOL," with 
. Easy!

// Lets strip the LF and CR from the descriptions   
    $new_Line = array('
', '
', '');
    $replace = '';

    $short_Description = str_replace($new_Line, $replace, $short_Description);
    $description = str_replace($new_Line, $replace, $description);

// OK now we have one big long line lets add the CR or maybe LF back at the end of each line where we've put the FEOL place holder
    $eol   = 'FEOL,';
    $replace = '';

    $short_Description = str_replace($eol, $replace, $short_Description);
    $description = str_replace($eol, $replace, $description);

Just wondering if their's anything obvious that I'm missing, or maybe I'm going about it all wrong. Any help would be greatly appreciated. Nigel

Answer 1

You are replacing "slash n" and "slash r" instead of LF and CR characters here:

$new_Line = array('
', '
', '');

Use double quotes:

$new_Line = array("
", "
", "");

You can see the difference yourself:

<?php
print '
';

Will print:

While

<?php
print "
";

Will print a newline character

Are you sure, that it should be " " and not " "?