RE: [sqr-users] Reading fillers from a file

["Aguirre, Jose" <JAguir@lsuhsc.edu>]

Create a temp table and then write the input data into it - then write to 
another file from the temp table.  Do not ltrim or rtrim the values from the 
temp table.


José A. Aguirre

-----Original Message-----
From: sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org 
[mailto:sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org] On Behalf Of Peter Burton
Sent: Monday, December 11, 2006 5:23 PM
To: This list is for discussion about the SQR database reportinglanguage 
fromHyperion Solutions.
Subject: RE: [sqr-users] Reading fillers from a file

Bob,

According to the SQR Language Reference Manual, trailing blanks are stipped 
from text records are that processed ...

Text and binary data is parsed according to the following:

        Text data is any string of characters. The length of the variable name 
indicates how many characters to place into the variable. After being 
transferred, trailing blanks in the variable are omitted.

Peter

-----Original Message-----
From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf Of 
Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Monday, December 11, 2006 2:37 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Reading fillers from a file

Hi,

    Iam facing a truncation issue when ever i read contents from a file and 
write to another file. I have a sorce file that has data some thing like this 
3933904l d944 krp9 kr 99 . There is one space after value 99.
But when i read the line and write to another file that single space gets 
truncated. Is there any way to preserve that space while writing to another 
file.
Any suggestions/ideas are welcome.

Thanks
Bob

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


If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited. Internet communications are not secure and Hyperion does 
not, therefore, accept legal responsibility for the contents of this message 
nor for any damage caused by viruses. The views expressed here do not 
necessarily represent those of Hyperion. For more information about Hyperion, 
please visit our Web site at: www.hyperion.com



_______________________________________________
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