Brian Dunning's FileMaker Custom Functions

MultiValue_To_ReportLine ( Text_Field )

converts list to readable sentence

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

Robert Schaub   Robert Schaub
Robert Schaub
http://none.com

Share on Facebook Share on Twitter

  Sample input:
New York Yankees
New York Jets
Norwich University Cadets
  Sample output:
New York Yankees, New York Jets And Norwich University Cadets

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

Removes carriage returns and inserts a comma between values. In between last two values inserts the word and rather than a comma

 

Comments

Super   Super, Malaysia
May 11, 2013
Hi,

There is an error.
Need to replace 'parent::field 1' with Text_Field

Otherwise, works great

Thanks
 

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.