Excel Tools

Hi, we are using import csv to database and it works great also for bigger files, with just one exception. Some of the fields in our CSV (which we unfortunately cannot change) contain quotes inside the text, e.g.:

0000|Some Text|"text in quotes" more text|00|123|6789

which is causing the error message invalid char between encapsulated token and delimiter

when searching the internet I found that in apache csv libraries there is also the option to ignore quotes https://stackoverflow.com/questions/26729799/invalid-char-between-encapsulated-token-and-delimiter-in-apache-commons-csv-libr -> CSVFormat.DEFAULT.withQuote(null)

are these libraries used in the plugin? if yes, would it be possible to add this parameter? this would be of great help for us!

Hi, we are using import csv to database and it works great also for bigger files, with just one exception. Some of the fields in our CSV (which we unfortunately cannot change) contain quotes inside the text, e.g.:

0000|Some Text|"text in quotes" more text|00|123|6789

which is causing the error message invalid char between encapsulated token and delimiter

when searching the internet I found that in apache csv libraries there is also the option to ignore quotes https://stackoverflow.com/questions/26729799/invalid-char-between-encapsulated-token-and-delimiter-in-apache-commons-csv-libr -> CSVFormat.DEFAULT.withQuote(null)

are these libraries used in the plugin? if yes, would it be possible to add this parameter? this would be of great help for us!