Disable escape character in CSV Import

3
Using the CSV Module from App Store I want to import an Excel CSV which means no escape character. See also org.apache.commons.csv.CSVFormat.EXCEL “abc\\def” in the text literally means abc\\def not abc\def I tried passing an empty string as the CSV Import activity parameter “Escape character” This leads to: Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 0 at java.base/java.lang.StringLatin1.charAt(StringLatin1.java:47) at java.base/java.lang.String.charAt(String.java:693) at csv.actions.ImportCSV.executeAction(ImportCSV.java:72) I tried passing the value “empty”. This leads to: Caused by: java.lang.UnsupportedOperationException: The separator, quote, and escape characters must be different! at com.opencsv.CSVParser.<init>(CSVParser.java:211) at com.opencsv.CSVParserBuilder.build(CSVParserBuilder.java:138) at csv.actions.ImportCSV.executeAction(ImportCSV.java:74) The other values can possible be encountered in the text so I don’t want to use them.
asked
0 answers