3 Replies Latest reply: Oct 6, 2012 2:54 AM by Giulio Valeri RSS

    CSV file export issue, any thoughts?

      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