Use quotes with export for fields containing comma

  • 1
  • Question
  • Updated 6 years ago
Could you look at the following enhancement:Some fields, for example company names, contain a comma. E.g. Apple, Inc.If you export this to a csv file, the column mapping is shifting due to this.Could you apply the following enhancement:PAVILION17","Lluis","BONICAXARXA","Adobe Systems, Inc.","Adobe Photoshop CS2","9.0","Hewlett-Packard"so enclose fields in quotes.Should be similar to this:select h.name,h.userid,h.workgroup,s.publisher, s.name,s.version,h.wincompany,h.winowner,h.ipaddr,h.id,h.processort,h.memory,h.osname,h.osversion,h.oscomments,h.winprodid,h.w inprodkey,h.useragent,h.lastdateINTO OUTFILE 'c:/users/lluis/lluis ocs softwares outfile.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM softwares s, hardware h WHERE s.hardware_id= h.id;Regards, Ben"
Photo of Emma at Get Satisfaction

Emma at Get Satisfaction

  • 526 Posts
  • 0 Reply Likes

Posted 6 years ago

  • 1

Be the first to post a reply!