Pad ( _input ; _char ; _length ; _left_or_right )

Padds a string on a given length, left or right. Not Recursive.

Average rating: 4.2 (39 votes) Log in to vote

Fabrice Nordmann - Show more from this author
1-more-thing
https://www.1-more-thing.com

Sample input:

Pad ( "James" ; "+-" ; 10 ; "Left" )
Pad ( "45.52" ; "." ; 15 ; "Right" )

Sample output:

James+-+-+

..........45.52

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

/* Pad ( _input ; _char ; _length ; _left_or_right )

by Fabrice Nordmann

v.1, Nov 2007


Padds a string on a given length, left or right.
Not recursive.

Pad ( "James" ; "+-" ; 10 ; "Left" )  --> "James+-+-+"
Pad ( "45.52" ; "." ; 15 ; "Right" )   --> "..........45.52"

*/

Let ([ 
    _str = Substitute ( ( 10  ^  _length ) - 1 ; 9 ; _char )
  ; _side = Case ( _left_or_right = "right" or _left_or_right = "r" ; "R" ; "L" )
];
Case ( _side = "L"
   ; Left ( _input & _str ; _length ) ; Right ( _str & _input ; _length )

)
)

Padds a string on a given length, left or right. Not Recursive.

Comments

		whardy Aug 13, 2020
Can someone tell me why the 9 in the Substitute function works like it does? I can't find any documentation on this. It's a great function! I'm just trying to figure out why it works.

		Fabrice Nordmann, 1-more-thing Aug 13, 2020
hello, just do the math ;) 10-1 = 9 100-1 = 99 1000-1 = 999...

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

Pad ( _input ; _char ; _length ; _left_or_right )

Comments

Support this website.

Support this website.