Brian Dunning's FileMaker Custom Functions

AddConstantToListValues ( theList ; theConstant )

Concatenate each value in a list with constant piece of text.

  Average rating: 4.1 (32 votes) Log in to vote

Simon Plint   Simon Plint
Thanks For The Memories

Share on Facebook Share on Twitter

  Sample input:
theList = "ID1crID2crID3"
theConstant = "_Mark"

(cr: carriage return)
  Sample output:

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

A recursive function that adds theConstant to each value in theList. theList is contains values separated by carriage returns.

Can be used to calculate a multi value match key from a multivalue key field and a constant.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.