Bruno,
Thanks for the response. The only problem is that FM removes all the leading
spaces. I may have been unclear in stating my problem. I want the padding on
the left; however, I don't want the extra space for the sign (+,-) that gets
prepended to the string. This output shows what I mean:
On Tue, Dec 13, 2005 at 11:30:36 -0500,
Terry Lee Tucker <[EMAIL PROTECTED]> wrote:
>
> On Tuesday 13 December 2005 11:20 am, John Sidney-Woollett saith:
> > Not sure if there is a numeric formatting option that allows what you want.
> >
> > But how about?
> >
> > substr(to_char(1029, '9,999'),2
On Tuesday 13 December 2005 11:20 am, John Sidney-Woollett saith:
> Not sure if there is a numeric formatting option that allows what you want.
>
> But how about?
>
> substr(to_char(1029, '9,999'),2)
That's so simple, I'm embarrased ;o)
Thanks for the help...
>
> John
>
> Terry Lee Tucker said:
Not sure if there is a numeric formatting option that allows what you want.
But how about?
substr(to_char(1029, '9,999'),2)
John
Terry Lee Tucker said:
> Greetings List:
>
> I am using to_char to format numeric data into a string that is ultimately
> displayed in an XmText widget. Much of the
Greetings List:
I am using to_char to format numeric data into a string that is ultimately
displayed in an XmText widget. Much of the numeric data is always going to be
positive. In some of the windows that display this data, space is at a
premium. Basically, I need to display something like 1,
