TalkPHP - View Single Post - Importing comma-delimited csv file, containing commas

Salathe · 10-30-2009, 03:38 PM

That data appears to be not comma-separated, but tab-separated. The commas shouldn't be an issue if you specify the correct delimiter (comma in CSV, tab in TSV, etc.).

PHP Code:


			
$handle = fopen("test.tsv", "r");
while (($row = fgetcsv($handle, 1000, "\t")) !== FALSE) {
    print_r($row);
}
fclose($handle);

Code:

Array
(
    [0] => Wiley, Jimmie
    [1] => 963144
)
Array
(
    [0] => Johnson, Michelle
    [1] => 1009959
)
Array
(
    [0] => Lynn, Kenya
    [1] => 1183526
)
Array
(
    [0] => Johnson, Gregory
    [1] => 1189881
)
Array
(
    [0] => Dixon, Kendric
    [1] => 1189915
)

10-30-2009, 03:38 PM	#9 (permalink)
Salathe Moderateur Join Date: Apr 2007 Posts: 1,239 Thanks: 3	That data appears to be not comma-separated, but tab-separated. The commas shouldn't be an issue if you specify the correct delimiter (comma in CSV, tab in TSV, etc.). PHP Code: `$handle = fopen("test.tsv", "r"); while (($row = fgetcsv($handle, 1000, "\t")) !== FALSE) { print_r($row); } fclose($handle);` Code: Array ( [0] => Wiley, Jimmie [1] => 963144 ) Array ( [0] => Johnson, Michelle [1] => 1009959 ) Array ( [0] => Lynn, Kenya [1] => 1183526 ) Array ( [0] => Johnson, Gregory [1] => 1189881 ) Array ( [0] => Dixon, Kendric [1] => 1189915 ) __________________ salathe@php.net