Brian Dunning's FileMaker Custom Functions

AbsolutePaddingZeroes ( number ; digits )

Pads a number to have static length of digits

  Average rating: 4.2 (46 votes) Log in to vote

Gjermund Gusland Thorsen   Gjermund Gusland Thorsen
Gudthlandum Consulting

Share on Facebook Share on Twitter

  Sample input:
AbsolutePaddingZeroes( 123766; 10 )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Pads a number to have static length of digits, max 100 for this example.

Might also work with string...



Erich   Erich, Germany
Jul 24, 2012
Why not:

Klaus   Klaus, Köln
Mar 9, 2016
Because this must not be a calculation.

0+1 = 1
"0"&1 = 01

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.