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

Andrew Sasaki - Show more from this author

Sample input:

PaddedText (1; "0"; 2)

PaddedText (12; "0"; 2)

PaddedText ("Hello"; "x"; 8)

PaddedText ("Hello World!"; "x"; 8)

Sample output:

"01"

"12"

"xxxHello"

"Hello World!"

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

Let ( [ SourceText = GetAsText ( Source ) ; 
SourceLength = Length ( SourceText ) ; 
TargetLength = If ( NumberOfChars > SourceLength ; NumberOfChars ; SourceLength ); 
FirstFillChar = If (Length ( FillChar ) > 0 ;  GetAsText ( Left ( FillChar ; 1 ) ) ; " ") ]; 
If ( SourceLength < TargetLength ; PaddedText ( FirstFillChar & SourceText; FirstFillChar; NumberOfChars) ; SourceText )
)

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

Comments

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

PaddedText ( Source ; FillChar ; NumberOfChars )

Comments

Support this website.

Support this website.