[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Still Need Help with numeric formatting



The problem with what you are doing is that the edit mask is used to
format a numeric variable when you are moving it into a string variable.
Since you are moving a string to a numeric, it ignores the mask.  Try
moving the string value to a numeric and then dividing the numeric by 100
(or whatever amount is needed to adjust the decimal point).

On Fri, 11 Sep 1998, Dominick Logiudice wrote:

> I have data on a file looks like this 099.
> I read into a variable $MASTER_FTE
>
> I am trying to use the edit command to format it to 0.99 or even .99
> I can divide by 100 and I get it 0.99.
> But whats wrong with the way I am editing it
>
> I have tried
> LET $MASK = '9.99'
> MOVE $MASTER_FTE to #MASTER_FTE :$MASK result is 99.0
>
> LET $MASK = '9.99'
> MOVE $MASTER_FTE to $MASTER_FTE :$MASK result is 99.0
>

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"