(PHP ActiveX) CSV Enable Quotes

Explains the EnableQuotes property for the CSV class.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows Note: The php_com_dotnet.dll may need to be enabled inside of php.ini.

<?php

// The CSV in this example contains this:   test;"123;abc";xyz

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Csv')
$csv = new COM("Chilkat.Csv");

// EnableQuotes is 1 by default, but we'll explicitly set to 1 here:
$csv->EnableQuotes = 1;
$success = $csv->LoadFile('qa_data/csv/enableQuotes.csv');

// Show row 0, column 0
print $csv->getCell(0,0) . "\n";
// Show row 0, column 1
print $csv->getCell(0,1) . "\n";
// Show row 0, column 2
print $csv->getCell(0,2) . "\n";

// Output is: 
//  test
//  123;abc
//  xyz

// -------------------------------------------
// Turn off EnableQuotes and see what happens:

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Csv')
$csv2 = new COM("Chilkat.Csv");
$csv2->EnableQuotes = 0;

$success = $csv2->LoadFile('qa_data/csv/enableQuotes.csv');

print $csv2->getCell(0,0) . "\n";
print $csv2->getCell(0,1) . "\n";
print $csv2->getCell(0,2) . "\n";
print $csv2->getCell(0,3) . "\n";

// Output is:

//  test
//  "123
//  abc"
//  xyz

?>