tototoshi/scala-csv

fail to read value with double quotes

xieyuheng opened this issue · 5 comments

xieyuheng commented

can handle this:

Foo,Bar,Baz
a,"B",c
d,e,f

but can not handle this:

Foo,Bar,Baz
a,Block "B",c
d,e,f

error message:

[ERROR] Exception in thread "main" com.github.tototoshi.csv.MalformedCSVException: a,Block "B",c
xieyuheng commented

"com.github.tototoshi" %% "scala-csv" % "1.3.6",

xieyuheng commented

I tried quoting = QUOTE_NONE
but still the error

xieyuheng commented

I can work around this by using:

implicit object MyFormat extends DefaultCSVFormat {
  override val delimiter = '|'
  override val quoteChar = '憂'
  override val escapeChar = '憂'
}

assuming the char '憂' will not appear in the csv file.

xieyuheng commented

the problem is that QUOTE_NONE will only effect CSVWriter, but not CSVReader

xieyuheng commented

Sorry I did a PR, without you confirming this problem first.

I need your library to do my work.
I will use my fork for now.

#149