# Data exchange definition: Import CSV file with double quotes in a field's value

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:

Related
Recommended