[CSV-200] CSVFormat cannot read its own output if input contain escape character followed by quote character

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4
• Component/s: Parser
• Assignee: Unassigned
• Reporter: Vladimir Eatwell
• Created: 24/Oct/16 13:11
• Updated: 10/Nov/19 21:09

Description

I can format CSV using CSVFormat that is subsequently unparsable by CSVFormat, the test below illustrates the failure:

import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVRecord;
import org.apache.commons.csv.QuoteMode;
import org.junit.Test;

import java.io.StringReader;
import java.util.List;

public class CSVFormatTest {

    @Test
    public void parseFailure() throws Exception {
        CSVFormat formatter = CSVFormat.DEFAULT;
        formatter = formatter.withDelimiter(',');
        formatter = formatter.withQuote('*');
        formatter = formatter.withEscape('/');
        formatter = formatter.withNullString("NULL");
        formatter = formatter.withIgnoreSurroundingSpaces(true);
        formatter = formatter.withQuoteMode(QuoteMode.MINIMAL);

        String formatted = formatter.format("bob/*", "token");
        List<CSVRecord> parsed = formatter.parse(new StringReader(formatted)).getRecords();
        for (CSVRecord record : parsed) {
            System.out.println(record.size());
        }
    }
}

Issue Links

• is duplicated by: CSV-249 ArrayIndexOutOfBoundsException when trying to read record written by CSVPrinter using CSVParser with same format
• is related to: CSV-208 Fix escape character for POSTGRESQL_TEXT and POSTGRESQL_CSV formats.