How to format a number preceded by a zero

[nycL45]

I have searched the manual and here for help with this and strangely, I found nothing. I tried several approaches to format the field within the script and the results.

I have a serial number produced with a Loop and want the result if < 10 to be preceded by a zero for sorting purposes. (I believe FM, like spreadsheets, requires a zero before single digits.) The script, i.e., the bcooney/Daniele script, follows below.

Thanks,

Leonard

[Lee Smith]

If the field is a pure number, then a 0 is not needed to sort. However, if you have text characters in the field too (can't tell from the description), then the field will need to be Text, not Number.

Lee

Is this a duplicate post?

Edited November 23, 2008 by Guest

[nycL45]

Thanks for that, Lee.

Leonard

[Vaughan]

Lee wrote: "If the field is a pure number..."

I think Lee meant that the field definition needs to be set to number, rather than text. Text fields get sorted alphabetically (1, 10, 2, 20 etc) whereas number fields sort numerically (1, 2, 10, 20 etc).