Skip to content
Advertisement

php fputcsv and enclosing fields

I was just about to ask the same questions as the question aksed here…. Forcing fputcsv to Use Enclosure For *all* Fields

The question was

When I use fputcsv to write out a line to an open file handle, PHP will add an enclosing character to any column that it believes needs it, but will leave other columns without the enclosures.

For example, you might end up with a line like this

11,”Bob “,Jenkins,”200 main st. USA “,etc

Short of appending a bogus space to the end of every field, is there any way to force fputcsv to always enclose columns with the enclosure (defaults to a “) character?

The answer was:

No, fputcsv() only encloses the field under the following conditions

/* enclose a field that contains a delimiter, an enclosure character, or a newline */
if (FPUTCSV_FLD_CHK(delimiter) ||
  FPUTCSV_FLD_CHK(enclosure) ||
  FPUTCSV_FLD_CHK(escape_char) ||
  FPUTCSV_FLD_CHK('n') ||
  FPUTCSV_FLD_CHK('r') ||
  FPUTCSV_FLD_CHK('t') ||
  FPUTCSV_FLD_CHK(' ')
)

There is no “always enclose” option.

I need to create a CSV file will every field enclosed… What would be the best solution?

Thanks in advance…

Advertisement

Answer

Roll your own function – its not hard:

 function dumbcsv($file_handle, $data_array, $enclosure, $field_sep, $record_sep)
 {
     dumbescape(false, $enclosure);
     $data_array=array_map('dumbescape',$data_array);
     return fputs($file_handle, 
         $enclosure 
         . implode($enclosure . $field_sep . $enclosure, $data_array)
         . $enclosure . $record_sep);
 }
 function dumbescape($in, $enclosure=false)
 {
    static $enc;
    if ($enclosure===false) {
        return str_replace($enc, '\' . $enc, $in);
    }
    $enc=$enclosure;
 }

(above is using unix style escaping)

C.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement