topic Re: CSV file export issue, any thoughts? in QlikView

CSV file export issue, any thoughts?

Tue, 21 Aug 2012 18:43:49 GMT

I am exporting a straight table as a .csv file. The requirement is to have each field wrapped in double quotes so I concatenated them to the field itself, i.e.,

'"' & Material & '"' as PARTNUMBER,

and I even tried,

CHR(34) & Material_MATNR & CHR(34) as PARTNUMBER

however, when I view the .csv file after export in Notepad or WordPad, I see 3 sets on each end of the field value, i.e.,

"""Y6015"""

Any thoughts on how I can get each field value wrapped in a set of quotes like this " Field Value " ?

Also, I am using QV v10 but will be moving this to v11 next week.

Thanks,

Sean

Re: CSV file export issue, any thoughts?

Tue, 21 Aug 2012 19:57:18 GMT

It seems that QlikView is adding the double qoutes automatically when you're exporting data as CSV when necessary, that is if a values contains either a double quote or a comma.

Is it definitely necessary for you to wrap all values in double quotes, even if they don't contain any of these two symbols? Most CSV parsers should be able to handle this format I think.

Re: CSV file export issue, any thoughts?

Tue, 21 Aug 2012 21:00:39 GMT

Thanks for the reply.

I am waiting for feedback now about the madatory double quotes. I know that QV11 doesn't allow most macros so I am not sure how to handle it if the requirement comes back with the mandatory double quotes.

Sean

Re: CSV file export issue, any thoughts?

giuval45 — Sat, 06 Oct 2012 06:54:07 GMT

Hi Sean,

I have the same problem...

Do you have been able to take away this "triple" quote output? 😉

Many thank and best regards,

Giulio