Reading from comma or tab delimited text file

Question

I need to read the data from a file that can be either comma or tab delimited. I now that there is a function getcsv but it accepts only one possible delimiter.

Any ideas how to handle this?

Thanks.

Answer 1

Starting from PHP 5.3, you can use str_getcsv() to read individual lines using different delimiters.

$someCondition = someConditionToDetermineTabOrComma();  $delimiter = $someCondition ? "," : "\t";  $fp = fopen('mydata.csv', 'r');  while ( !feof($fp) ) {     $line = fgets($fp, 2048);      $data = str_getcsv($line, $delimiter);      doSomethingWithData($data); }                                fclose($fp); 

Answer 2

You can specify a delimiter for fgetcsv(). This is an example of reading tab-delimited files,

 while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE) {     ...  }