mapJoin ( pre ; sep ; post ; str ; i ; values )

Combines multiple values into a single string

Average rating: 2.5 (2 votes) Log in to vote

belg4mit - Show more from this author

Sample input:

mapJoin("'"; ","; "'"; ""; 1; "foo¶bar¶qux")

Sample output:

'foo','bar','qux'

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

Let ( [
  vals= ValueCount ( values );
  str= str & pre & GetValue(values; i) & post;
  str=Case(i<vals; str&sep; str)
] ; 

Case( i<vals; mapJoin(pre; sep; post; str; i+1; values); str)

)

This maps over a list of values, decorating them with pre and post text, joining the result with a separator. A sample use case is to take a collection of record IDs and combine them into a string for use in an ExecuteSQL IN clause such as:

ExecuteSQL("SELECT Fred FROM Barney WHERE Wilma IN("&mapJoin("'"; ","; "'"; ""; 1; $IDS)&")"; ""; "")

Comments

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

mapJoin ( pre ; sep ; post ; str ; i ; values )

Comments

Support this website.

Support this website.