convert from csv to tab delimited using PHP

[andylink]

Tweet

Hi all

Heres my problem

I have a product file in csv that I would like to parse and place in a MYSQL table. I am running into problems with the product descriptions containing commas because the comma is used as the delimiter. If I convert the csv to tab manually, my code is fine and everything parses correctly.

My Question

Is it possible to use PHP to convert a file from csv to tab delimited so I don't have to manually convert it, or does somebody know of any easy way of escaping the commas in the descriptions and leaving the file as a csv?

My head is now hurting.

Thanks

Andy

[futureweb]

use fgetcsv loop through each line inserting as you go?

somthing like

$myfile = "path/to/csv.csv";
// open for reading
  $csv_fp = fopen ($myfile, "r");

   // add a counter for fun may come in ron!
 $rows = 0;
// start loop
          while ($data = fGetCsv ($csv_fp, 10000, ",")) 
{
// un delimit if your first row of the csv is a column header
// if($rows == 0){
// do nothing as its column header
// }else{ // do insert

// how many columns? 
$num = count($data);

for ($c=0; $c < $num; $c++) {
       echo $data[$c] . "<br />\n";
   }

// }

// Count 
$rows++;

} // End the loop


          fclose ($csv_fp); 

[andylink]

Thanks for the reply, will read through it and see if I can make sense of it.

Cheers

Andy