visualiseNumbers ( content ; string ; value )

To convert a list of numbers into a text line of characters defined by the numbers

Average rating: 4.4 (35 votes) Log in to vote

Tim Anderson - Show more from this author
Tim Anderson Group

Sample input:

visualiseNumbers ( "5¶4¶5¶8" ; "x" ; 3 )

Sample output:

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

/*

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)



)
)

To convert a list of numbers into a text line of characters defined by the numbers

Comments

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

visualiseNumbers ( content ; string ; value )

Comments

Support this website.

Support this website.