ConcatListAndConstant ( theList ; Constant ; Place ; Separator )

Concatenate a constant with each value in a return-separated list, as prefix or suffix

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

Matt Wills - Show more from this author
Virtual Vermont
http://www.virtualvermont.com/FMP/

Sample input:

Where theList is
John
Paul
George
Ringo

Constant is Beatle

Separator is " " (space)

Sample output:

Place is "Prefix"
Beatle John
Beatle Paul
Beatle George
Beatle Ringo

or

Place is "Suffix"
John Beatle
Paul Beatle
George Beatle
Ringo Beatle

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

/* ConcatListAndConstant ( theList ; Constant ; Place ; Separator) */

Let ( [
theValue = GetValue ( theList ; 1 ) ;
Pos = Position ( theValue ; Constant ; 1 ; 1 ) ;
NewValue =
Case (
Place = "Prefix" ; Constant & Separator & theValue ;
Place = "Suffix" ; theValue & Separator & Constant ) ] ; 

If ( IsEmpty ( theList ); theList;

If ( Pos = 0 ; NewValue ; theValue )

&
 
If ( ValueCount ( theList ) > 1 ; "¶" ; ""  )

&

ConcatListAndConstant ( RightValues ( theList ; ValueCount ( theList ) - 1 ) ; Constant ; Place ; Separator)

))

Expands on Simon Plint's AddConstantToListValues cf, allowing you to choose whether Constant is placed in front of (Prefix) or behind (Suffix) the list value, as well as to specify character(s) to be inserted as a separator.

I use Prefix and Suffix only to make the function more clear. You can substitute 1 and 2, P and S, whatever you like.

This Version 2 will add Constant only if it is not already there. If you use this as an auto-enter calculation, you can add a value to the list on the fly and Constant will be concatenated only to the new value.

Comments

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

ConcatListAndConstant ( theList ; Constant ; Place ; Separator )

Comments

Support this website.

Support this website.