This is an old revision of the document!
You can use PHP to quickly get a column of data from a CSV file. A file I have has the following format.
"John", "Doe", "801-555-5555"
PHP has the function fgetcsv() which is great for grabbing data from a CSV file.
Here's an example script where I loop through a CSV file grabbing the 3rd column of information.
<?php // File and column $file = 'myfile.csv'; $column = 3; // Subtract one from the column because fgetcsv is zero based $column = $column - 1; // Open the file for reading if (($handle = fopen($file, "r")) === FALSE) { echo "Couldn't open file."; } // Loop through the file one CSV line at a time while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { // Output the specified column for this line echo $data[$column] . "\n"; } // Close the file fclose($handle);
To use that script, simply change the $file value to the file you want to open and the $column value to the column number you want to extract. Save the file as getcol.php and then run it with the following command.
php getcol.php