.NET Core C#

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. .NET Core 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