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

CR/LF in text files

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › CR/LF in text files

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • March 16, 2003 at 6:42 pm #13921
      CalEvans
      Member

      I understand your problem as I've run into it many times before. However, I disagree as to the solution. I like the fact that SQLyog is not 'feature rich' as some others. It is a tool with the minimum features necessary to do the job. This is an issue that can easily be dealt with in a number of ways. I don't think it is SQLyog's place to fix the problem.

      That having been said, have you tried specifying n AND the code for CR ? (Don't know it off the top of my head, sorry.) If SQLyog will not allow you to specify more than 1 code in the line termination box then THIS is an issue they should deal with.

      =C=

    • March 16, 2003 at 6:42 pm #13920
      Ritesh
      Member

      You can specify the Escape Characters in your Text/CSV file by clicking on the Change… button in the Import From CSV File… Dialog box.

      If the lines are terminated by CRLF then you can give rn in the Lines Terminated By… field and SQLyog will correctly import your data.

      Quote:
      The default separation character is t but text file extension used is CSV (comma separated value). It's confusing but I can live with that.

      Its like that because it is common among developer/administrators to export data where fields are separated by t 😀

    • March 17, 2003 at 1:42 pm #13922
      Ritesh
      Member
      Quote:
      If SQLyog will not allow you to specify more than 1 code in the line termination box then THIS is an issue they should deal with.

      You can specify more then one code in the line termination box. Most often for Windows file, it will be rn

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