Brian Dunning's FileMaker Custom Functions

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   Matt Wills
Virtual Vermont
http://www.virtualvermont.com/FMP/

Share on Facebook Share on Twitter

  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)

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

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.