[MAYBE SPAM] converting numerics

[Chris Sharman]

Kristina Carlton wrote:
> I am writing out data via Quiz extracts. Due to the size of the files we 
> are using the subfiles versus the textfiles and I noticed that my number 
> formats are gone in the subfiles. I tried the PICTURE command but it 
> basically ignores it. So for example, 114.56 looks like +00000011456. 
> When we read this data into our Progress database, it comes in as 11,456.
> 
> Is the only way to get around this in Quiz to convert the numerics to 
> ASCII and then physically place the decimal? If so, do I have to check 

The best ascii conversion routine is formatnumber (present in more 
recent Powerhouse versions I believe - 7.10F+ for VMS) - this allows you 
to do just about everything you could want.
The ascii function is, as you've noticed, very basic.

Chris



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.