Details
Description
In Camel org.apache.commons.csv.CSVFormat is indirectly configured via org.apache.camel.model.dataformat.CsvDataFormat. Although it is possible to tell CSVFormat to trim leading and trailing blanks via CSVFormat.withTrim, this property can NOT be set in CsvDataFormat.
Workaround
As a workaround, one could do the following:
CsvDataFormat dataFormat = new CsvDataFormat("\t") { @Override protected void configureDataFormat(DataFormat dataFormat, CamelContext camelContext) { // This is how we force the engine to trim the values org.apache.camel.dataformat.csv.CsvDataFormat csvDataFormat = (org.apache.camel.dataformat.csv.CsvDataFormat) dataFormat; CSVFormat format = csvDataFormat.getFormat(); csvDataFormat.setFormat(format.withTrim()); super.configureDataFormat(csvDataFormat, camelContext); } };
Question
Are they other properties which should be considered?