Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Carriage Return Command


Message #1 by "Nathan Crawford" <nathan.crawford@f...> on Wed, 18 Apr 2001 18:11:30 +0900
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Hello All
:
: Periodically running a text file in ANSI out of DTS Wizard from an NT/SQL7
: origin to a UNIX destination. The carriage return command, char(13), that
: works for the destination server's text editor is not supported by any
other
: text editors. Is there a command that supports carriage return across all
: text editors?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Chr(13) should give you a CR.

That said, all a CR does it return the cursor to the start of the current
line. Usually you want to do a CR, and then a LF - ie return the cursor to
the start of the line, and then move forward 1 line.

Chr(13) & Chr(10)  - or - Chr(10) & Chr(13) - or - vbCrLf (in VB/VBScript)

should give you what you want.

Cheers
Ken


  Return to Index