All Forums Tools
Koentje 23 posts Joined 09/04
08 Apr 2014
Fastloading csv file with double quotes

How are you fast loading a csv file where the fields are enclosed by double quotes?
“Field 1”;”Field 2”;”Field 3”
“Fi””eld 1”;”Field “”2”””;”Field 3”
What is the method you’re using?

SuSeSi 61 posts Joined 10/08
14 Apr 2014

If you are using 14.00 or later, you can have fastload using following syntax:


Koentje 23 posts Joined 09/04
15 Apr 2014

Hi Sudhansu,
thank you very much.
We installed the version some days ago. This is great news.

Koentje 23 posts Joined 09/04
29 Apr 2014

After testing with data, we encountered following situation:
Snapshot of input data:


These rows were rejected due to the fact that the data itself contains double quotes (this is following the standards of quoted data).

**** 09:28:27 Error at record number 5
**** 09:28:27 Error on piom GET ROW: 64, Text: Quoted data- Column
              missing close quote !ERROR! Delimited Data Parsing error:
              Delimiter did not immediately follow close quote mark in
              row 6, col 1

What do I miss?

SuSeSi 61 posts Joined 10/08
02 May 2014

Fastload does not support or can ignore quoting character as part of data. The csv file while saving by different application adds additinal quotes for their application differently.
I will suggest in this case to use a shell/perl script to
1. change the quoted character ' " '
2. change the two double quote character which represent a single quote in data to one.
the data:
then use fastload command as:



You must sign in to leave a comment.