RE: [sqr-users] Format

["radhika reddy" <radhika_05@hotmail.com>]

Don,

Thanks for all your suggesstions. finally i got it by doing it your way. i 
need not multiply or do anything, simply using edit mask. i got it.

Thanks,
Radhika


>From: Don Mellen <donm@ontko.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 reporting 
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Format
>Date: Fri, 24 Sep 2004 09:31:37 -0500 (EST)
>
>Or ...
>
>Simply use the edit mask of '000000009V999999'.  The V is an implied
>decimal point.
>
>
>On Fri, 24 Sep 2004, Murty Mirthipati Venkata Suryanarayan wrote:
>
> > I feel this is a better logic:
> >
> >     round it two decimals if required.
> >     Then multiply by 1000000
> >     Then lpad
> >
> >      What say, Radhika?
> >
> >
> > With Best Regards,
> > Murty MVS
> > Software Developer
> > *SunTrust Team*
> > JPC - 7flr; +9144-28241970 Ext:244
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Bob Stone [mailto:bstone@fastenal.com]
> > Sent: Friday, September 24, 2004 7:35 PM
> > To: 'This list is for discussion about the SQR database reporting
> > languagefrom Hyperion Solutions.'
> > Subject: RE: [sqr-users] Format
> >
> >
> > no.  i mean change the order of what the other guy said.
> >
> > multiply by 1000000 first (keeps the decimals)
> > THEN put it in an integer field
> > then pad the zeros.
> >
> > Or if you wanted just the 2 decimal places you could multiply by 100 
>first,
> > then round it, then multiply by 1000 (=6 zeros). then pad the zeros.
> >
> >
> >
> > -----Original Message-----
> > From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
> > [mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
> > Murty Mirthipati Venkata Suryanarayan
> > Sent: Friday, September 24, 2004 9:03 AM
> > To: This list is for discussion about the SQR database reportinglanguage
> > from Hyperion Solutions.
> > Subject: RE: [sqr-users] Format
> >
> >
> > We said. May be Rounding by two digits will workout
> >
> >
> > With Best Regards,
> > Murty MVS
> > Software Developer
> > *SunTrust Team*
> > JPC - 7flr; +9144-28241970 Ext:244
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Bob Stone [mailto:bstone@fastenal.com]
> > Sent: Friday, September 24, 2004 7:19 PM
> > To: 'This list is for discussion about the SQR database reporting
> > languagefrom Hyperion Solutions.'
> > Subject: RE: [sqr-users] Format
> >
> >
> > 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
> >
> >
> > 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
> >
> > _______________________________________________
> > 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
> >
>
>-----------------------------------------------------------------------
>Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
>donm@ontko.com |  "In the beginning, there was nothing, which exploded"
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


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