FileMaker Pro Custom Functions

// Description: // AddConstantToListValues ( theList; theConstant ) // A recursive function that adds // theConstant to each value in theList. // theList contains values separated // by carriage returns. // Use: // Can be used to calculate a multi value match // key from a multivalue key field and a constant. // Author: // Written by Simon Plint // simonREMOVECAPITALSBEFOREUSEplint@mac.com // Algorythm: // Get the first value in the list that has // been passed in. Conactenate this value with // theConstant and a CR and the result of the // recursive call to AddConstantToListValues. // With each recursion we take the first value // of theList before we pass it. // If the list is empty don't add the CR. // // Code: If ( IsEmpty ( theList ); theList; GetValue ( theList ; 1 ) & theConstant & If ( ValueCount ( theList ) > 1 ; "¶" ; "" ) & AddConstantToListValues ( RightValues ( theList ; ValueCount ( theList ) - 1 ) ; theConstant ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.