Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

LeadingZeros ( value, numDigits )

Converts any number into a string and pads the number with leading zeros until the number of required digits is achieved.

  Be the first to rate this function Log in to vote

Kyle Williams - Show more from this author Augusto Digital https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

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

/* Author: Kyle Williams Date: 12/15/2020 Purpose: Adds Leading Zeros to any number Use Cases: Customize Variable Names Some APIs or EDI files require the use of leading zeros Note: This will not remove any digits, Supports up to 40 zeros Examples: LeadingZeros( 355, 1 ) = "355" LeadingZeros( 355, 8 ) = "00000355" */ GetAsText( Right( "0000000000000000000000000000000000000000" & GetAsText(value); Max( numDigits; Length(value)) )) Click to copy

Converts any number into a string and pads the number with leading zeros until the number of required digits is achieved.

 

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: