Brian Dunning's FileMaker Custom Functions

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   Anthony Reimer - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
StringBtwnChars ( "hello" , "-" ; 5 )
  Sample output:

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

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).



Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: