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
Constant is Beatle
Separator is " " (space)
Place is "Suffix"
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.