csvjdbc icon indicating copy to clipboard operation
csvjdbc copied to clipboard

Fixed-width input is always trimmed, regardless of trimValues setting

Open geert3 opened this issue 3 years ago • 2 comments

When reading a CSV with fixed width, white space is always trimmed. See CsvRawReader::parseFixedLine

values[i] = values[i].trim();

In my use-case, I have leading white space that should remain intact. I see several possible solutions:

  • only trim trailing white space for fixed-width input
  • trim white space only if 'trimValues' property is true (and perhaps make it true by default for fixed-width input)

geert3 avatar Mar 24 '21 09:03 geert3