Static_Length ( FillChar ; Len ; String ; LR_Flag )

Turns any string to a fixed length adding Leading or Trailing Char

Average rating: 4.4 (34 votes) Log in to vote

Antonios M. Kesmetzis - Show more from this author

Sample input:

Static_Length ( * ; 15 ; 10.0102 ; 2)
Static_Length ( * ; 15 ; 10.0102 ; 1)

Sample output:

********10.0102

10.0102********

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

/* 
Author: AnKe
Skopelos Island, Greece, Revised March 2009

Initially submitted as LeadingZeros

Based on the Daniele Raybaudi's Function Format Write ( char ; times )

Parameters
     String: Any number or text
     FillChar: Any character to fill
     Len: The desired legth of the resulted string
     LR_Flag: When its value is 1 the number is padded Left, i.e. Leading chars are added
                   When its value is 2 the number is padded Right, i.e. Trailing chars are added

             The functions returns a string of fixed length, defined by Len, with Leading or Trailing  chars, defined by FillChar
              and the value of LR_Flag

If the Length of the String exceeds Len the string unaltered is returned
*/

Case ( LR_Flag = 1 ; 
        Case (
                    Length ( GetAsText ( String ) )  - Len  <  0;
                    Static_Length (FillChar  ; Len - 1; String; 1) & FillChar;
                    String
                  ); 
        Case (
                     Len - Length ( GetAsText ( String ) ) > 0;
                     FillChar & Static_Length (FillChar  ; Len - 1; String; 2);
                     String
                  ) 
         )

Parameters
String: Any number or text
FillChar: Any character to fill
Len: The desired legth of the resulted string
LR_Flag: When its value is 1 the number is padded Left, i.e. Leading chars are added
When its value is 2 the number is padded Right, i.e. Trailing chars are added

The functions returns a string of fixed length, defined by Len, with Leading or Trailing chars, defined by FillChar
and the value of LR_Flag

If the Length of the String exceeds Len the string unaltered is returned

Comments

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

Static_Length ( FillChar ; Len ; String ; LR_Flag )

Comments

Support this website.

Support this website.