1

I want to export table to .csv I use ',' delimiter when exporting. But the weird thing is one of my column of my table has ',' in its content. So When I import csv to table it is confused. How can I solve this? How can I show true delimiter.

thanks in advance

CompEng
  • 7,161
  • 16
  • 68
  • 122

1 Answers1

0

I always use pipe |as delimiter, so in most cases there is not conflict with content.

jcbermu
  • 557
  • 6
  • 12
  • unfortunately it does conflict with my column :( it has pipe chars – CompEng Dec 17 '14 at 12:41
  • 1
    Surround each field in doublequotes. According to [RFC1480](http://tools.ietf.org/html/rfc4180) it should work. – jcbermu Dec 17 '14 at 12:46
  • so then How can I understand integer and string ? if every one has doublequotes , there should be some parameter when I want to import from csv to table – CompEng Dec 17 '14 at 12:56
  • Check this http://stackoverflow.com/questions/17808511/properly-escape-a-double-quote-in-csv – jcbermu Dec 17 '14 at 13:11
  • "so then How can I understand integer and string ? if every one has doublequotes" every value type is represented by a string. Double quote characters are just a way to delimit the contents of a field. It will still be up to Vertica to parse that string value into the appropriate type. – kimbo305 Dec 17 '14 at 23:24