Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Carriage Return

Author  Topic 

Rita Bhatnagar
Posting Yak Master

172 Posts

Posted - 2002-03-01 : 17:35:02
Hi,
i want to write a big text file.In that after every record i want to use carriage return to make them look separate Like one recode in one line and second in the second line.
Thanks for help.
Rita

JamesT
Yak Posting Veteran

97 Posts

Posted - 2002-03-01 : 17:45:29
Is this where you could create a format file with the last record delimiter be '|\n' where '|' is the delimiter and the '\n' is the new line character one the last line?

Go to Top of Page

JamesT
Yak Posting Veteran

97 Posts

Posted - 2002-03-01 : 17:56:01
For more information on this see Books on Line under the topic: Using Format Files

Go to Top of Page
   

- Advertisement -