From 24b62ea46a5cd87139364d7291eaf78dbb284aeb Mon Sep 17 00:00:00 2001 From: Jason Woofenden Date: Sat, 4 Feb 2012 19:06:00 -0500 Subject: [PATCH] csv: no trailing \t, no newlines within --- csv.php | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) diff --git a/csv.php b/csv.php index d2d90e3..f9e311a 100644 --- a/csv.php +++ b/csv.php @@ -4,14 +4,21 @@ # little sense, and does not actually have anything to do with commas. # pass in a 2d array (array of rows) and it'll send it to the browser +# I can't figure out how to get multi-line fields to work, so replace newlines with 4 spaces. function array2d_to_csv_download($data, $filename) { header('Content-type: application/csv'); header('Content-Disposition: attachment; filename=' . $filename); foreach($data as $row) { + $first = true; foreach($row as $el) { - echo '"' . str_replace('"', '""', $el) . "\"\t"; + if($first) { + $first = false; + } else { + echo "\t"; + } + echo '"' . str_replace("\n", " ", str_replace('"', '""', $el)) . '"'; } - echo "\n"; # apparently can be \n or \r\n + echo "\r\n"; } exit(); } -- 1.7.10.4