AddConstantToListValues ( theList ; theConstant )

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

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

Simon Plint - Show more from this author
Thanks For The Memories
http://thanks.com.au

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)

// 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 )
)

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

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

AddConstantToListValues ( theList ; theConstant )

Comments

Support this website.

Support this website.