Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
CHR(34)&Material&CHR(34)
CHR(34) = "
CHR(34)&Material&CHR(34)
CHR(34) = "
CHR(34)&Material&CHR(34)
CHR(34) = "
Thankf for the reply but I still got 3 sets on both ends of the field.
Have you got any solution? I am also facing similar problem. Please share if you have already resolved it!