topic Re: Concatenating double quotes to field, .CSV export Issue in QlikView

Concatenating double quotes to field, .CSV export Issue

Tue, 21 Aug 2012 16:15:29 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,

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: Concatenating double quotes to field, .CSV export Issue

jamiehicks71 — Tue, 21 Aug 2012 16:21:49 GMT

CHR(34)&Material&CHR(34)

CHR(34) = "

Re: Concatenating double quotes to field, .CSV export Issue

jamiehicks71 — Tue, 21 Aug 2012 16:22:03 GMT

CHR(34)&Material&CHR(34)

CHR(34) = "

Re: Concatenating double quotes to field, .CSV export Issue

jamiehicks71 — Tue, 21 Aug 2012 16:22:14 GMT

CHR(34)&Material&CHR(34)

CHR(34) = "

Re: Concatenating double quotes to field, .CSV export Issue

Tue, 21 Aug 2012 16:33:17 GMT

Thankf for the reply but I still got 3 sets on both ends of the field.

Re: Concatenating double quotes to field, .CSV export Issue

qlikviewforum — Sat, 06 Oct 2012 06:59:00 GMT

Have you got any solution? I am also facing similar problem. Please share if you have already resolved it!