JSON.MakeArrayObject ( ValueList ; Separator )

Simple function that wraps a list of values in an array object.

Be the first to rate this function Log in to vote

Jonni™ - Show more from this author

Sample input:

JSON.MakeArrayObject ( List ( 1;2;3;4;5 ) ; "¶" )

Sample output:

[1,2,3,4,5] or ["a","b","c","d","e"]

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

Let ( [

	~list = ValueList ; // List of values separated by a distinct marker
	~numb = Filter ( ~list ; "0123456789" & Separator ) ; // Clean value list containing only numbers and the separator
	~type = If ( Length ( ~list ) = Length ( ~numb ) ; 1 ; 0 ) ; // 0:string | 1:number
	~open = If ( ~type ; "[ " ; "[ \"" ) ; // Opening segment of array
	~close = If ( ~type ; " ]" ; "\" ]" ) ; // Closing segment of array
	~sep = If ( ~type ; "," ; "\",\"" ) // Substitution text separating items in array

] ; 

	~open & Substitute ( ~list ; Separator ; ~sep ) & ~close

)

// BD Link : https://www.briandunning.com/cf/2658
// Written by: jonni@me.com
// V 1.0

Simple function that wraps a list of values in an array object to be used within an array object in a JSON notation.

JSONSetElement ( "{}" ; "myArray" ; JSON.MakeArrayObject ( List ( 1;2;3;4;5 ) ; "¶" ) ; JSONArray )

or

JSONSetElement ( "{}" ; "myArray" ; JSON.MakeArrayObject ( List ( "a";"b";"c";"d";"e" ) ; "¶" ) ; JSONArray )

Comments

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

JSON.MakeArrayObject ( ValueList ; Separator )

Comments

Support this website.

Support this website.