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
http://www.thanks.com.au

Share on Facebook Share on Twitter

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

(cr: carriage return)
  Sample output:
ID1_Mark
ID2_Mark
ID3_Mark

  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.

 

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.