FileMaker Pro Custom Functions

/* -------------------------------------------------------------------------------- Returns a list with value 'value' inserted at position 'index' Syntax: InsertValue ( list ; value ; index ) In: list - the return delimited list to search value - the stringvalue to insert index - the position (1-...) where the new value should go If left empty or an integer value greater than the total size of the list, the new value will be added at the very end of the list. If <= 1 the value will added at the beginning of the list. Return type: Text (a list with leading and trailing returns removed) InsertValue ( "John¶Paul¶Ringo" ; "George" ; 3 ) --> "John¶Paul¶George¶Ringo" Theo Ros -------------------------------------------------------------------------------- */ Let ( [ value = LeftWords ( value ; 999999999 ) ; list = LeftWords ( list ; 999999999 ) ; totalvalues = ValueCount ( list ) ] ; Case ( totalvalues = 0 ; value ; IsEmpty ( index ) or index > totalvalues ; list & "¶" & value ; index < 2 ; value & "¶" & list ; LeftWords ( LeftValues ( list ; index - 1 ) & value & "¶" & MiddleValues ( list ; index ; 999999999 ) ; 999999999 ) ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.