RE: [sqr-users] Format

[Bob Stone <bstone@fastenal.com>]

uh, put it an integer field, multiply the decimal by 1000000, and pad the
zeros on the left?


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
radhika reddy
Sent: Friday, September 24, 2004 8:27 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Format



Thanks. I could display it that way but again my requirement has changed now

i want the decimal places also to be displayed without decimal something 
like

value              Output to be
>8989.78        000008989000000           changed to   000008989780000
>678              000000678000000
>
>
>I am writing code like this
>
>let $sal = edit($yrs,'000000009)

how to write the code to display decimal places without decimal?
Thanks.




>From: "Murty Mirthipati Venkata Suryanarayan" <murtym@hexaware.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Format
>Date: Fri, 24 Sep 2004 16:02:35 +0530
>
>Hi Radhika,
>        Hope the problem already vanished.
>
>        Else try the following:
>
>        Round the number to zero digits
>        Multiply the result with 1000000
>        Now LPad zeros with respect 15 digits
>
>
>       All the best..
>
>With Best Regards,
>Murty MVS
>Software Developer
>*SunTrust Team*
>JPC - 7flr; +9144-28241970 Ext:244
>
>
>
>
>
>
>
>
>
>
>-----Original Message-----
>From: radhika reddy [mailto:radhika_05@hotmail.com]
>Sent: Friday, September 24, 2004 12:05 AM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] Format
>
>
>Hi,
>
>      One of my fields which i want to be displayed in a txt file is of 
>size
>9.6
>I want my field(for example salary)
>
>value              Output to be
>8989.78        000008989000000
>678              000000678000000
>
>
>I am writing code like this
>
>let $sal = edit($yrs,'0009')
>
>and for zeroes in the last 6 places i am giving as:
>
>let $var1 =000
>
>and i am writing into file as
>
>write 1 from $sal:9 $var1:6
>
>is this the right way?
>
>Thanks.
>
>_________________________________________________________________
>FREE pop-up blocking with the new MSN Toolbar - get it now!
>http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>DISCLAIMER:
>Information contained and transmitted by this E-MAIL is proprietary to
>Hexaware Technologies and is intended for use only by the individual or
>entity to which it is addressed and may contain information that is
>privileged, confidential or exempt from disclosure under applicable law.
>If this is a forwarded message, the content of this E-MAIL may not have
>been sent with the authority of the Company. If you are not the intended
>recipient, an agent of the intended recipient or a person responsible
>for delivering the information to the named recipient, you are notified
>that any use, distribution, transmission, printing, copying or
>dissemination of this information in any way or in any manner is
>strictly prohibited. If you have received this communication in error,
>please delete this mail & notify us immediately at
>adminchn@hexaware.com.
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


_______________________________________________
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