Java

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. Java

import com.chilkatsoft.*;

public class ChilkatExample {

  static {
    try {
        System.loadLibrary("chilkat");
    } catch (UnsatisfiedLinkError e) {
      System.err.println("Native code library failed to load.\n" + e);
      System.exit(1);
    }
  }

  public static void main(String argv[])
  {
    boolean success = false;

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

    CkCsv csv = new CkCsv();

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

    //  Show row 0, column 0
    System.out.println(csv.getCell(0,0));
    //  Show row 0, column 1
    System.out.println(csv.getCell(0,1));
    //  Show row 0, column 2
    System.out.println(csv.getCell(0,2));

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

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

    CkCsv csv2 = new CkCsv();
    csv2.put_EnableQuotes(false);

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

    System.out.println(csv2.getCell(0,0));
    System.out.println(csv2.getCell(0,1));
    System.out.println(csv2.getCell(0,2));
    System.out.println(csv2.getCell(0,3));

    //  Output is:

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