RE: [sqr-users] Printing trailing spaces using Brio SQR

["Peter Burton" <peter.burton@oracle.com>]

Maddy,

Begin-Report
 Open 'q.dat' As 1 For-Writing Record=32767:Vary
 Let $String = RPad('Last-Line', 25, ' ')
 Write 1 From $String
 Close 1
End-Report 

You can also force a field to be a specific width and trailing blanks will be 
added

Begin-Report
 Open 'q.dat' As 1 For-Writing Record=32767:Vary
 Let $String = 'Final-Line'
 Write 1 From $String:25                ! Pad/Truncate to 25 characters
 Close 1
End-Report 

Either method will create the file "q.dat" and the line will have trailing 
blanks.

Peter

-----Original Message-----
From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of maddy
Sent: Thursday, August 02, 2007 9:51 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Printing trailing spaces using Brio SQR

I have a extract file that needs to be generated using a Brio SQR program in
which I want to fill the end of the 1st line with 25 spaces.
No matter whatever I do I am not able to print spaces at the end of the
line. I am using Ultra Edit editor where the spaces in a file are indicated
using dots. I am able to print spaces in the middle of a line whereas if I
try to print spaces at the end of the line, they are being truncated.

Can someone please give me some inputs on how to achieve this using Brio
SQR.


thanks
maddy

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users