Concatenating double quotes to field, .CSV export Issue

[#1]

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

[jamiehicks71]

CHR(34)&Material&CHR(34)

CHR(34) = "

[jamiehicks71]

CHR(34)&Material&CHR(34)

CHR(34) = "

[jamiehicks71]

CHR(34)&Material&CHR(34)

CHR(34) = "

[#5]

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

[qlikviewforum]

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