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

Reply via email to