• Reference
  • faq
  • About

kdbfaq

Answers. Fast.
  • Reference
  • faq
  • About

Top
  • Reference
  • faq
  • About
Navigation
  • Login
  • Register Now
Connect

Follow @kdbfaq

  • kdb faq RSS
Site Search
local site only
  • Debugging (4)
  • Functions (6)
  • General (22)
  • Language (10)
  • Operators (6)
  • Performance (10)
  • Special Values (3)
  • Syntax (31)
  • Tables (6)
  • Tricks (18)
  • Utilities (1)
Training
  • Videos
    • How can I measure the performance of my q code?
  • Basics
    • What exactly does column oriented mean?
      .
    • Does q pass-by-value or pass-by-reference?
      .
    • Is the q language simply syntactic sugar on top of k?
      .
    • What does it mean for q function or table to be a ‘first class’ type?
      .
    • How do I comment q code?
      .
    • I understand whitespace matters in q code. Where does it matter?
      .
    • How does 'protected execution' or exception handling in q work?
      .

Entries in read1 (1)

How do I load in a csv file into kdb with the headers as table fieldnames?

DateFriday, March 11, 2011 at 11:24PM

Insert the keyword enlist before the delimiter argument to 0: or 1:.

(“SSS”; enlist “,”) 0: `:filename.csv

See also: field parsing and operator 0:

Share ArticleShare Article CommentPost a Comment | tagged Tag0:, Tag1:, Tagcsv, Tagcsv file parsing, Tagenlist, Tagload csv, Tagread0, Tagread1, Tagtable header in CategorySyntax
http://www.kdbfaq.com/kdb-faq/how-do-i-load-in-a-csv-file-into-kdb-with-the-headers-as-tab.html
Tweet
Creative Commons License
This work is licensed under a Creative Commons License.
The views and opinions expressed herein are those of the authors and do not necessarily reflect those of any other person or legal entity.
Kdb+ is the registered trademark of Kx Systems, Inc.