export problem

[adunphy]

I'm doing a basic export and there are some either new lines or hidden characters mucking it all up. Any ideas?

while ($row = mysql_fetch_row($res)) {
$row[18]=str_replace("\r"," ",$row[18]);
$row[18]=str_replace("\n"," ",$row[18]);
$row[8]=str_replace("\r"," ",$row[8]);
$row[8]=str_replace("\n"," ",$row[8]);
$row[9]=str_replace("\n"," ",$row[9]);
$row[9]=str_replace("\r"," ",$row[9]);
$row[21]=str_replace("\r"," ",$row[21]);
$row[21]=str_replace("\n"," ",$row[21]);

// check to see if a comma exists in the field
// $variable = str_replace("\,", "", $row);
fwrite($fp, join($delim, $row) . "\n");
}

TNX!

[AstroTeg]

\r is a carriage return
\n is a carriage return and linefeed

Both of them can cause problems. Without looking at the output you're getting, you might try replacing both, the \r and \n.

Also, what are you exporting to? It appears like you're working with text, but you're not wrapping the text in quotes. Some programs actually handle carriage returns rather nicely when you have quotes around the text (such as most newer MS Office apps).

[adunphy]

how do I put quotes around it?

[AstroTeg]

You're using join() which will work, but may require some tweaking. Check out what you're using for $delim. I'm guessing it equals something like = ','. You might try doing $delim = '","'; But you will HAVE to look at the output. I'm going to guess if you do this, you'll find the first element in each row will be missing a quote and the last element may be missing an closing quote. This can be fixed by wrapping quotes around the finished join() function.