[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] RE: preserving "leading zeros" in a string
- Subject: RE: [sqr-users] RE: preserving "leading zeros" in a string
- From: "Aguirre, Jose" <JAguir@lsuhsc.edu>
- Date: Mon, 14 Feb 2005 15:31:39 -0600
- Delivery-date: Mon, 14 Feb 2005 16:32:58 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Did you create the .csv file from excel? Make sure to open the .csv file on
a text editor to make sure that zeroes are preserved there. How are you
unstringing the values in your SQR?
Thanks,
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 ruscs
___
Sent: Monday, February 14, 2005 3:25 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] RE: preserving "leading zeros" in a string
Hello,
I am exporting string values (which may contain numeric values) into a csv
file. Some of these numeric values may contain leading zeros (for example,
001111, 02222...) When the import is complete, leading zeros are lost.
(1111, 2222). How can these leading zeros be preserved?
Thanks for your help!
_______________________________________________
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