Unsupported Screen Size: The viewport size is too small for the theme to render properly.

import csv question

forums › forums › SQLyog › Using SQLyog › import csv question

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • February 15, 2003 at 7:34 pm #7692
      cseelig
      Member

      Sorry for being dense, but is there a way to import a tab-delimited

      text file with lines that end in PC-style cr-lf? My attempts at this

      have worked (sort of), but the last column includes the “extra”

      delimiter. I notice that I can customize the end-of-line delimiters

      via the import utility, but I can't figure out what to specify.

      Thanks!

    • February 17, 2003 at 7:12 pm #13744
      Ritesh
      Member

      Can you give me more information about how the fields are terminated/enclosed etc.

    • February 18, 2003 at 3:45 pm #13745
      cseelig
      Member

      The file is an ordinary Windows/DOS text file.

      Lines are delimited by a carriage-return/line-feed pair.

      Fields (columns) are delimited by a tab character.

      Fields are not further enclosed (no quotes around text fields, for example).

      It appears that, in the mode in which I'm using the import facility,

      the utility is expecting a Unix-style text file, in which fields are

      delimited by a single character (line feed?).

      Thanks.

    • February 18, 2003 at 6:26 pm #13746
      Ritesh
      Member

      Hope the configuration shown in the image below will help you.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.