var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Unable to insert new line character in a file
I am using Sybase ASE 12.5.4 Enterprise Edition on Windows XP.
I have written a stored procedure that actually writes to a physical file on hard drive. For this, I am using ASE_XFS feature.
Data is successfully written to file. But I am not able to insert a new line character. I tried \n,\r,\r\n.
Everything is written on same line.
Following is sample code,
set @vFileHeader = 'Data File Header' + '\n'
insert into PT_PCDFILE values (@vFileHeader)
Here PT_PCDFILE is a Proxy table that refers to some file like text1.txt.
Thanks in advance! Does anyone has suggestion?
I think in Windows new line is equiv to CR (Carriage Return) + (LF) LineFeed.
Originally Posted by august97
Try char(13) instead of \n
It worked! Thanks a lot!
This problem had become a roadblock for me. Thanks again!