[CSV-288] String delimiter (||) is not working as expected.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.10.0
• External issue URL: https://github.com/apache/commons-csv/pull/218
• Assignee: Unassigned
• Reporter: Santhsoh
• Created: 03/Sep/21 13:28
• Updated: 14/Sep/22 12:09
• Resolved: 19/Feb/22 16:57

Description

Steps to reproduce  : 
1. Parse CSV file with || as delimiter and having empty columns
2. Print the CSVRecord resulting from CSVParser

 
//Expected : a,b,c,d,,f,g
// Actual : a,b|c,d,|f,g

public static void main(String[] args) throws Exception{
String row = "a||b||c||d||||f||g";
StringBuilder stringBuilder = new StringBuilder();
try (CSVPrinter csvPrinter = new CSVPrinter(stringBuilder, CSVFormat.EXCEL);
CSVParser csvParser = CSVParser.parse(new StringInputStream(row), StandardCharsets.UTF_8, CSVFormat.Builder.create().setDelimiter("||").build())) {
for (CSVRecord csvRecord : csvParser) {
for (int i = 0; i < csvRecord.size(); i++)

{ csvPrinter.print(csvRecord.get(i)); }

System.out.println(stringBuilder.toString());
//Expected : a,b,c,d,,f,g
// Actual : a,b|c,d,|f,g
}
}
}

With the snippet provided above, actual value is not same as expected value

Issue Links

• is related to: CSV-206 Add support for String delimiters #76