FileMaker Pro Custom Functions

/* Name: visualiseNumbers History: Created by Tim Anderson, Tim Anderson Group www.timanderson.co.uk Creation Date: 29 April 2009 Purpose: To convert a list of numbers into a text line of characters defined by the numbers Parameters: Content string value Example: visualiseNumbers ( "5¶4¶5¶8" ; "x" ; 3 ) gives |xxxxx|xxxx|xxxxx|xxxxxxxx| Requires Other Custom Functions: string.repeat(str;number) If (number > 0 ; str & If ( number > 1 ; string.repeat ( str ; number - 1) ; "") Other Notes: The value must always be the number of values-1. Options: None */ // visualiseNumbers( Content ; string; value) Let(_NumVals=ValueCount(Content); Case(_NumVals-value>_NumVals;"|"; "|"& string.repeat ( string ; GetValue(content; _NumVals-value)) & visualiseNumbers(content;string;value-1) ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.