Computer Programming CookBook

Here is a very simple code you can use to generate your csv file : unlink("upload.csv"); $handle_out = fopen("upload.csv", "a"); $fields_put=array('sku', 'name', 'price', 'short_description', 'description', 'attribute_set', 'type', 'status', 'visibility', 'tax_class_id', 'category_ids', 'weight'); fputcsv($handle_out, $fields_put, '|' ,'"'); while ($row = mysql_fetch_array($result)) { $description=ereg_replace( "\r\n", "", $row['short_description']); $description=ereg_replace( "\r\t", "", $description); $description=ereg_replace( "\r", "", $description); $description=ereg_replace( "\t", "", $description); $description=ereg_replace( "\n", "", ...

PHP remove hidden character like line breaks and tabs and hidden character like following: $description=ereg_replace( "\r\n", "", $row['short_description']); $description=ereg_replace( "\r\t", "", $description); $description=ereg_replace( "\r", "", $description); $description=ereg_replace( "\t", "", $description); $description=ereg_replace( "\n", "", $description); $description=ereg_replace( "\xA0", "", $description); $description=ereg_replace( "\x0B", "", $description); $description=ereg_replace( '"', '""', $description);  This really helps when you are creating a CSV file which has line breaks. Some softwares like magento doesn't import the csv file properly if you have line breaks or hidden characters in your text. It counts each hidden character as new line.