~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: 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