PaddedText ( Source ; FillChar ; NumberOfChars )
Pads a text string to a specific number of characters using a fill character.
Average rating: 4.4 (32 votes) Log in to vote
PaddedText (12; "0"; 2)
PaddedText ("Hello"; "x"; 8)
PaddedText ("Hello World!"; "x"; 8)
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Will add fill characters to text until the text is the desired length. Can be used to add leading zeroes to digits, etc. -- see cample input and output for examples. All outputs are text. It also has the following characteristics:
-Accepts integers as the source text
-If no fill character is supplied, the default is a space
-If the length of the source string is longer than the target length, the source string is unaltered
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.