StringBtwnChars ( mainString ; stringBtwn ; mainLength )

Places spaces or other characters between each character of a text string

Average rating: 4.3 (30 votes) Log in to vote

Anthony Reimer - Show more from this author

Sample input:

StringBtwnChars ( "hello" , "-" ; 5 )

Sample output:

h-e-l-l-o

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

If ( mainLength ≤ 1 ; 
   mainString ; 
   StringBtwnChars ( Left ( mainString ; mainLength - 1 ) & stringBtwn & Right ( mainString ; Length ( mainString ) - mainLength + 1  ) ; stringBtwn ; mainLength - 1 )
)

This function was designed to create a more extended version of a text field by placing spaces between each character in the original field. However, any character or pattern of characters may be specified in the second parameter. It uses recursion to process the original string from right to left, so it will process however many characters from the left that you specify in the mainLength parameter (normally, Length ( mainString )). It does not trap for erroneous input (e.g., mainLength is greater than length of the string).

Comments

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

StringBtwnChars ( mainString ; stringBtwn ; mainLength )

Comments

Support this website.

Support this website.