Phil: In BASIC:
OCONV((wkVal < 0), 'S;"-";""') : ABS(wkVal) "R(%6)" In AQL (assuming value is in attribute/field 001): DICT FILENAME 'TEST' size = 76 01 S 02 1 03 Value 04 05 06 07 08 AIF 1 < '0' THEN 1(S;'-';''):1(MCN)(MR%6) ELSE 1(MR%6) 09 R 10 7 Hope this helps. Bill > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Phil Walker > Sent: Wednesday, March 10, 2004 8:53 PM > To: U2 Users Discussion List > Subject: Formating Negative Numbers > > > Does anyone have a quick way to format a negative number in a field filled > with zeros such that the '-' sign appears at the front replacing the 1st > zero. > > For example > > -2 using 'R%6' becomes 0000-2 > 2 using 'R%6' becomes 000002 > > But I would like -2 to become -00002 and 2 to remain 000002. I > know I could > write code to do this, but I was wondering if you can do it just using the > fmt syntax. > > Regards, > > Phil Walker > +64 21 336294 > [EMAIL PROTECTED] > infocusp limited > \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz > DISCLAIMER: This electronic message together with any attachments is > confidential. If you are not the intended recipient, do not > copy, disclose > or use the contents in any way. Please also advise us by return > e-mail that > you have received the message and then please destroy. infocusp limited is > not responsible for any changes made to this message and / or any > attachments after sending by infocusp limited. We use virus scanning > software but exclude all liability for viruses or anything similar in this > email or any attachment > > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
