Repeat ( textToRepeat ; numberOfRepetitions )

Have you ever wanted to repeat a simple string and don't want to have to create loops and things to do so? Well here you go.

Be the first to rate this function Log in to vote

Kevin Y - Show more from this author
Beezwax

Sample input:

Repeat ( "Hello" ; 3 )

Sample output:

"HelloHelloHello"

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

Substitute ( ( 10^numberOfRepetitions ) - 1 ; 9 ; textToRepeat )

10^2 = 100 - 1 = 99
99 has 2 nines and substitute replaces those each 9s with your text.
10^3 - 1 = 999 ... You see my point.

Comments

		Tim Anderson, Tim Anderson Group Jan 15, 2025
Interesting Kevin, is this just an interesting way to achieve the result or are there benefits over other methods?

		Michael Horak, *COMMENT Visual Realisation Apr 2, 2025
Compare: https://www.briandunning.com/cf/942

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