Gautham Arunachalam created CSV-312:
---------------------------------------
Summary: CSV Header with multiple lines throughs error
Key: CSV-312
URL: https://issues.apache.org/jira/browse/CSV-312
Project: Commons CSV
Issue Type: Bug
Components: Parser
Reporter: Gautham Arunachalam
CSV file header is in multi-line while trying to read the file invalid char
between encapsulated token and delimiter error is thrown
Sample CSV:
{code:java}
"SYMBOL
","COMPANY
","PURPOSE
","DETAILS
","DATE
"
"AURIONPRO","Aurionpro Solutions Limited","Fund Raising","To consider and
approve the Issue price, including a discount if any","08-Apr-2024"
"CUPID","Cupid Limited","Financial Results/Other business matters","To consider
and approve the financial results for the period ended March 31, 2024 and other
business matters","08-Apr-2024"
"DPWIRES","D P Wires Limited","Other business matters","To consider other
business matters","08-Apr-2024" {code}
Code used to read
{code:java}
Reader in = new FileReader(file);
Iterable<CSVRecord> records = CSVFormat.RFC4180.parse(in);
for (CSVRecord record : records) {
System.out.println(record.get(0));
} {code}
Occurring Error :
{code:java}
Exception in thread "main" java.io.UncheckedIOException: IOException reading
next record: java.io.IOException: (line 2) invalid char between encapsulated
token and delimiter
at
org.apache.commons.csv.CSVParser$CSVRecordIterator.getNextRecord(CSVParser.java:150)
at
org.apache.commons.csv.CSVParser$CSVRecordIterator.hasNext(CSVParser.java:160)
at com.gautham.stockmarket.tools.Main.main(Main.java:21)
Caused by: java.io.IOException: (line 2) invalid char between encapsulated
token and delimiter
at org.apache.commons.csv.Lexer.parseEncapsulatedToken(Lexer.java:369)
at org.apache.commons.csv.Lexer.nextToken(Lexer.java:290)
at org.apache.commons.csv.CSVParser.nextRecord(CSVParser.java:770)
at
org.apache.commons.csv.CSVParser$CSVRecordIterator.getNextRecord(CSVParser.java:148)
... 2 more {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
