InsertCharacter ( text ; index ; char )
Inserts a specified character in between each character of a specified string.
Average rating: 4.3 (32 votes) Log in to vote
Bell Mountain Assoc.
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Inserts a specified character in between each character of a specified string. The variable "index" needs to be the length of the "text" string.
Sep 13, 2013
Am I missing something here? When I use this function (which is very cool, btw), it also inserts a trailing char…
The above mentioned sample output is on my machine: F_i_l_e_m_a_k_e_r_
It doesn't matter in my database, but it would be nicer if the trailing char would not be there.
Anyone any ideas?
Sep 28, 2013
Case ( Index < 2 ; Text ;
InsertCharacter ( Replace ( Text ; Index ; 0 ; chr ) ; Index - 1 ; chr )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.