C#

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. C#

bool success = false;

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

Chilkat.Csv csv = new Chilkat.Csv();

//  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
Debug.WriteLine(csv.GetCell(0,0));
//  Show row 0, column 1
Debug.WriteLine(csv.GetCell(0,1));
//  Show row 0, column 2
Debug.WriteLine(csv.GetCell(0,2));

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

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

Chilkat.Csv csv2 = new Chilkat.Csv();
csv2.EnableQuotes = false;

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

Debug.WriteLine(csv2.GetCell(0,0));
Debug.WriteLine(csv2.GetCell(0,1));
Debug.WriteLine(csv2.GetCell(0,2));
Debug.WriteLine(csv2.GetCell(0,3));

//  Output is:

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