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

Extra character at end of each row after CSV impor

forums › forums › SQLyog › Using SQLyog › Extra character at end of each row after CSV impor

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • December 15, 2004 at 1:28 am #8699
      showson1
      Member

      Hi all!

      Just started messing with SQLyog and I really like it so far!

      When I do a CSV import (actually tab dilimited text) everything imports fine except for the fact that there's a square at the end of each row.

      I exported this file from Excel so I'm sure it has something to do with Window's txt format.. but can't figure out a way around it.

      I'm on XP Service Pack 2

      If anyone could help out I'd appreciate it!

      Thanks!

      Steve

    • December 15, 2004 at 4:03 am #16703
      Ritesh
      Member

      The square seems to be some sort of control character.

      What do you mean by:

      Quote:
      the end of each row

      Are you getting the characters in the actual data or in the result display window?

    • December 15, 2004 at 5:39 pm #16704
      caves
      Member

      You should use rn as your “Line Terminate By” , that will solve your problem.

    • December 15, 2004 at 7:55 pm #16705
      showson1
      Member
      caves wrote on Dec 15 2004, 05:39 PM:
      You should use rn as your “Line Terminate By” , that will solve your problem.

      caves,

      That did the trick… thanks a lot!

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