Brian Dunning's FileMaker Custom Functions

ZeroNum ( number ; len )

Returns a number with leading zeroes

  Average rating: 4.1 (32 votes) Log in to vote

Theo Ros   Theo Ros
*
n/a

Share on Facebook Share on Twitter

  Sample input:
ZeroNum ( 123 ; 7 )
  Sample output:
0000123

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

Returns a string containing the number with as many leading "0" characters as needed to reach the given total length.

In: number - the number to format
len - the total length of the
returned string

Return type: Text

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.