[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