1 Reply Latest reply: Feb 18, 2012 9:20 PM by EdStevens RSS

    Sqlplus line terminators

    911268
      Hello,

      I use SqlPlus utility to generate a report on Linux server, that is uploaded to Windows server and read by users, sometimes by pretty stupid tools like Notepad. I need to change the line terminators from LF to CR/LF, but I din't find any solution that would do it directly. I can't process that report after its generated, because the mechanism of uploading is part of a bigger system and we are not able to change it.

      Thanks,

      Michal

      Edited by: 908265 on 16.1.2012 1:57
        • 1. Re: Sqlplus line terminators
          EdStevens
          908265 wrote:
          Hello,

          I use SqlPlus utility to generate a report on Linux server, that is uploaded to Windows server and read by users, sometimes by pretty stupid tools like Notepad. I need to change the line terminators from LF to CR/LF, but I din't find any solution that would do it directly. I can't process that report after its generated, because the mechanism of uploading is part of a bigger system and we are not able to change it.

          Thanks,

          Michal

          Edited by: 908265 on 16.1.2012 1:57
          How is the file moved from linux to windblows? Just about any utility I can think of (ftp, sftp, scp, etc,, etc, has the option to copy as either binary or text. Choose text and it will make the conversion. Also google unix2dos and dos2unix.