CommaToList ( commaValues )

Converts comma separated values to standard list with values separated by return

Be the first to rate this function Log in to vote

Lazarus Sismanis - Show more from this author
Decision Group
http://www.decisiongroup.net

Sample input:

CommaToList ( "Value One, Value Two, Value Three" )

Sample output:

Value One
Value Two
Value Three

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

/**
* =====================================
*	CommaToList ( commaValues )
*
* PURPOSE:
*	Converts comma separated values to standard Filemaker value list with values separated by return ( ¶ )
* 
* RETURNS: 
*	(string) value list
*
* PARAMETERS:
*	commaValues = A list of comma separated values
*
* EXAMPLE: 
* 	CommaToList ( "Value One, Value Two, Value Three" ) =
* 
* 	Value One
* 	Value Two
* 	Value Three
*
* DEPENDENCIES:
*	none
*
* NOTES:
*	Makes input more readable when passing value lists to other calculations, custom functions or field entries.
*	
* HISTORY:
*	CREATED: 2020-06-15: by Lazarus Sismanis ( lazarus@decisiongroup.net )
*
* =====================================
*/

Let ( 
	[ 
	~myList = TrimAll ( Substitute ( commaValues ; "," ; Char(13) )  ; 1 ; 1 )

	];

	~myList

)

Converts comma separated values to standard Filemaker value list with values separated by return ( ¶ ). Makes input more readable when passing value lists to other calculations, fields or custom functions.

Comments

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

CommaToList ( commaValues )

Comments

Support this website.

Support this website.