Re: Converting tab delimited file to CSV

Back to my 'original' problem/question, if I '$f = fopen("$file", "r")' and 'while ($data = fgets($f))' on the above first format and do a $data = str_replace("\t",",",$data); the resulting file looks like the second example above when opened into Textpad but will not open into separate columns when opened with Excel.

Look up http://www.php.net/fgetcsv and pass "\t" as the field separator. -- Postgresql & php tutorials http://www.designmagick.com/