[CSV-297] setHeader() does not consider the separator while parse header row

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Component/s: Parser
• Assignee: Unassigned
• Reporter: Marco Cuccato
• Created: 27/May/22 10:53
• Updated: 27/May/22 12:13
• Resolved: 27/May/22 12:13

Description

If you try to parse a file like this:

name$value
a$1
b$0
c$3

with a CSVFormat defined like this:

CSVFormat.DEFAULT.builder()
                .setRecordSeparator("$")
                .setHeader()
                .build(); 

and then try to retrieve a field by name with:

record.get("name")

i get the following error:

 

java.lang.IllegalArgumentException: Mapping for name not found, expected one of [name$value]
    at org.apache.commons.csv.CSVRecord.get(CSVRecord.java:121)
 

Looks like the parser does not consider the separator when auto detects headers.

If I modify the source file using comma as separator and 

format.setRecordSeparator(",")

 it works.