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

Share on Facebook Share on Twitter

  Sample input:
StringBtwnChars ( "hello" , "-" ; 5 )
  Sample output:
h-e-l-l-o

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

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.