JavaScript

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class.

Note

This example is intended for running within a Chilkat.Js embedded JavaScript engine. All Chilkat JavaScript examples require Chilkat v11.4.0 or greater.

JavaScript

var success = false;

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

var csv = new CkCsv();

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

// Show row 0, column 0
console.log(csv.GetCell(0,0));
// Show row 0, column 1
console.log(csv.GetCell(0,1));
// Show row 0, column 2
console.log(csv.GetCell(0,2));

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

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

var csv2 = new CkCsv();
csv2.EnableQuotes = false;

success = csv2.LoadFile("qa_data/csv/enableQuotes.csv");

console.log(csv2.GetCell(0,0));
console.log(csv2.GetCell(0,1));
console.log(csv2.GetCell(0,2));
console.log(csv2.GetCell(0,3));

// Output is:

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