Brian Dunning's FileMaker Custom Functions

ReplaceInList ( theList , offset , value )

Replaces item number offset in theList with the value.

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

Don Aehl   Don Aehl
none
http://nop

Share on Facebook Share on Twitter

  Sample input:
ReplaceInList ( "apple¶orange¶grape" , 3 , "banana" )
  Sample output:
"apple¶orange¶banana"

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

Replaces item number offset in theList with the value.
If offset < 1 then it appends value to front of list.
if offset > count of list, then it appends value to end of list.

ex: ReplaceInList ( "apple¶orange¶grape" , 3 , "banana" ) = "apple¶orange¶banana"

 

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.