fixed lenght file with a CR-LF at the end of each row 2

[alectek]

Hi!
I have a requirement from the State to import file is in ASCI, fixed length with a CR-LF at the end of each row. Each row represents one service record.
I use Crystal Reports 11 with SQL Server 2005 to get those services. Should I export result of Crystal into Excel in than save is .prn file? Then, how can I add CR-LF to the end?
Thank you.

Al.

Thanks.
Alec.

 

[Madawc]

Chr(13) is the ASCII Carriage Return. You could set this value in a formula field and then include the formula field as needed.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[alectek]

It is working. Thank you.

Thanks.
Alec.

 

[lbass]

If you need both a character return and a line feed, then you should know that chr(10) is for the line feed.

-LB