I need to import a CSV file, but some lines have double quotes inside fields. e.g. “Massiv eg 2"”";“3,00”;"";“3,14”
Excel can open such file without any issue and will show text <Massiv eg 2">
But NAV understands it as a separator. And thus shifting values to the next columns.
The easiest way it seems like to have some macros to replace “” (but to keep <"";> ). But maybe it’s already implemented inside BC?
My Data exchange definition setup:
