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

Ersin Gülbahar
  • 6,713
  • 15
  • 60
  • 114

1 Answers1

0

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

jcbermu
  • 548
  • 7
  • 12
  • unfortunately it does conflict with my column :( it has pipe chars – Ersin Gülbahar 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 – Ersin Gülbahar 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