[RESOLVED] Import excel file as something other than CSV

[austenr]

Hi,

I have an excel file I need to import into a table. The description field has commas that need to be in there. ex. man,bites,dog. What is the best way to save and import this file? I thought about changing all of the commas in the name to something else, importing it as a CSV file then using an ALTER TABLE command to put the commas back but I'm not sure of the syntax. Thanks

[NogDog]

If you save it as CSV from Excel, Excel is smart enough to know that fields which contain commas must be quoted. If you use PHP's [man]fgetcsv/man function to read that CSV file, it is smart enough to know how to deal with quoted fields and that they may contain commas.

[austenr]

I just tried that. Still won't parse correctly. Here is an example of the data in a zip file.

[NogDog]

Works fine for me. I just took a small section of the CSV:

"DEB;SKIN,PT",11040, 156.60 , 95.53 ,761
"DEB;SKIN,FT",11041, 578.40 , 352.82 ,761
DEB;SKIN&SQ TISS,11042, 649.20 , 396.01 ,761
"DEB;SKIN,SQ TISS,MUSC",11043, 822.00 , 501.42 ,761
"DEB;SKIN,SQTISS,MUSC,BONE",11044," 1,014.60 ", 618.91 ,761
PAR/CUT BEN HYPERKER;SING,11055, 112.20 , 68.44 ,761
PAR/CUT BEN HYPERKER;2_4,11056, 127.20 , 77.59 ,761
PAR/CUT BEN HYPERKER;5+,11057, 145.20 , 88.57 ,761
"BIO SKIN,SQ&/M;SING",11100, 192.60 , 117.49 ,761
"BIO SKIN,SQ&/M;EA SEP/ADD",11101, 135.00 , 82.35 ,761
REM SKIN TAG;1_15,11200, 192.60 , 117.49 ,761
REM SKIN TAG;ADD 10,11201, 214.80 , 131.03 ,761
"SH EP/DER,1,TA/L;0-0.5",11300, 111.60 , 68.08 ,761
"SH EP/DER,1,TA/L;0.6-1",11301, 127.80 , 77.96 ,761
"SH EP/DER,1,TA/L;1.1-2",11302, 157.20 , 95.89 ,761

I ran this code against it:

<?php
$fh = fopen('test.csv', 'r') or die("fopen() failed");
echo "<table border='1' cellspacing='0' cellpadding='2'>";
while(($line = fgetcsv($fh)) !== FALSE)
{
   echo "<tr>";
   foreach($line as $cell)
   {
      echo "<td>$cell</td>";
   }
   echo "</tr>\n";
}
echo "</table>\n";
?>

I got this result:

[austenr]

Thanks. That worked fine.