Java

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. Chilkat2 Java

import com.chilkatsoft.chilkat2.Csv;

public class ChilkatExample {

    public static void main(String[] args) {
        // The CSV in this example contains this:   test;"123;abc";xyz

        Csv csv = new Csv();

        // EnableQuotes is true by default, but we'll explicitly set to true here:
        csv.setEnableQuotes(true);
        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:

        Csv csv2 = new Csv();
        csv2.setEnableQuotes(false);

        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
    }
}