MultiValue_To_ReportLine ( Text_Field )

converts list to readable sentence

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

Robert Schaub
Robert Schaub
http://none.com

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)

//Robert Schaub 04/13/2013

Substitute( Text_Field ;[ ¶ ; ", "] ; [", " & GetValue ( parent::field 1; ValueCount(Text_Field) ); " And " & GetValue (Text_Field; ValueCount(Text_Field) ) ] )

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

Comments

		Super, Malaysia May 11, 2013
Hi, There is an error. Need to replace 'parent::field 1' with Text_Field Otherwise, works great Thanks

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

MultiValue_To_ReportLine ( Text_Field )

Comments

Support this website.

Support this website.