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

Edit masks, zero fill with minus sign



I am writing an sqr that creates a file that is sent to a third party
vendor.  The requirements are for a zero filled number with a minus sign if
the number is a negative.  The format is S9(7)v9(2).

I am having trouble combining the zero fill and minus sign.  If I put MI at
the end of the format, it will give me a minus sign, but truncate the
negative number.  For a positive number it will just truncate it.

         move #amount to #dedamt
                    do Format-Number(#dedamt,$dedamt,'0999999Vmi')

Any suggestions are appreciated.

Thanks
Kelli Kidd
Kidd Konsulting, Inc.
kelli_kidd@tiginsurance.com