Leading zeros

429 views
Skip to first unread message

Erik

unread,
Jul 24, 2009, 11:22:31 AM7/24/09
to XMPie Interest Group
I have a field in UDirect that is just a listing of numbers. I would
like to pad to leading zero's. Is there an easy way to do this. I have
tried to add the 0's to the listing and Udirect just takes them off.
Any help would be great.

Thank you

George Marsh

unread,
Jul 24, 2009, 11:33:43 AM7/24/09
to xmpie...@googlegroups.com
You need to

Format(|->[the field], "0000")

Try looking in the help for examples

2009/7/24 Erik <eri...@gmail.com>:

Erik

unread,
Jul 24, 2009, 11:42:44 AM7/24/09
to XMPie Interest Group
Sorry missed the format command in there. Thank you for your help it
worked great.

On Jul 24, 11:33 am, George Marsh <george.ma...@gmail.com> wrote:
> You need to
>
> Format(|->[the field], "0000")
>
> Try looking in the help for examples
>
> 2009/7/24 Erik <erik...@gmail.com>:

Bill

unread,
Jul 24, 2009, 2:14:14 PM7/24/09
to XMPie Interest Group
If you are a QLingo extremist, you will certainly prefer using
"FormatNumber", as the old "Format" command is now deprecated.

Timothy Perrett

unread,
Jul 24, 2009, 2:29:16 PM7/24/09
to xmpie...@googlegroups.com
Qlingo extremist eh Bill?! What a thought that is! Haha

Cheers, Tim

Sent from my iPhone
Reply all
Reply to author
Forward
0 new messages