RE: [sqr-users] Need a trailing space

["Hins, Thomas D. \(HSC\)" <Thomas-Hins@ouhsc.edu>]

Have you tried setting a variable to Char 32 and concantenaeting your variable 
with your data?  I have done this with line feed and carraige returns, 
personally unless you really have data that space delimited will work with I 
would use something like a tilda instead or as a recent post used a semicolon.  
I have found data to sometimes contain semicolons so I tend to stick with 
tilda. 
Tom Hins
Information Technology - Application Solutions
University of Oklahoma Health Sciences Center
P.O. Box 26901
Oklahoma City, OK  73190
Phone:(405) 271-2262 Ext. 50213
Fax: (405) 271-2352
(The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. If you 
are not the intended recipient of this message you are hereby notified that any 
use, review, retransmission, dissemination, distribution, reproduction or any 
action taken in reliance upon this message is prohibited. If you received this 
in error, please contact the sender and delete the material from any computer. 
Any views expressed in this message are those of the individual sender and may 
not necessarily reflect the views of the company.)



-----Original Message-----
From: sqr-users-bounces+thomas-hins=ouhsc.edu@sqrug.org
[mailto:sqr-users-bounces+thomas-hins=ouhsc.edu@sqrug.org]On Behalf Of
Gopa, Rajesh
Sent: Wednesday, June 16, 2004 7:59 AM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] Need a trailing space


With print.


-----Original Message-----
From: sqr-users-bounces+rgopa=knighttrading.com@sqrug.org
[mailto:sqr-users-bounces+rgopa=knighttrading.com@sqrug.org]On Behalf Of
the dragon
Sent: Wednesday, June 16, 2004 8:54 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Need a trailing space


How are you creating your file?  With a print, or with a write?

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

I am generating a space delimited .lis file. Last character should be a 
space. How can I achieve it in Sqr Version 3.0.7?

I used -XTB and -PB but it does not work.

I tried to rpad the field and print it ,even it does not work.

Any help is appreciated.

Thanks,
Rajesh




DISCLAIMER
This e-mail, and any attachments thereto, is intended only for use by the 
addressee(s) named herein and may contain legally privileged and/or 
confidential information. If you are not the intended recipient of this 
e-mail, you are hereby notified that any dissemination, distribution or 
copying of
this e-mail, and any attachments thereto, is strictly prohibited. If you 
have received this e-mail in error, please immediately notify me and 
permanently delete the original and any copy of any e-mail and any printout 
thereof.
E-mail transmission cannot be guaranteed to be secure or error-free.  The 
sender therefore does not accept liability for any errors or omissions in 
the contents of this message which arise as a result of e-mail transmission.
NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
Knight Trading Group may, at its discretion, monitor and review the content 
of all e-mail communications.

_______________________________________________
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


DISCLAIMER 
This e-mail, and any attachments thereto, is intended only for use by the 
addressee(s) named herein and may contain legally privileged and/or 
confidential information. If you are not the intended recipient of this e-mail, 
you are hereby notified that any dissemination, distribution or copying of
this e-mail, and any attachments thereto, is strictly prohibited. If you have 
received this e-mail in error, please immediately notify me and permanently 
delete the original and any copy of any e-mail and any printout thereof. 
E-mail transmission cannot be guaranteed to be secure or error-free.  The 
sender therefore does not accept liability for any errors or omissions in the 
contents of this message which arise as a result of e-mail transmission. 
NOTICE REGARDING PRIVACY AND CONFIDENTIALITY 
Knight Trading Group may, at its discretion, monitor and review the content of 
all e-mail communications.

_______________________________________________
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