[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"