ExtractAllTextValuesForKey ( json ; key )

Extracts JSONString values from JSON at whatever depth

Be the first to rate this function Log in to vote

Richard Dyce - Show more from this author
Dyce & Sons Ltd.
http://dyce.com

Sample input:

ExtractAllTextValuesForKey ( "[ { \"content\": [ { \"text\": \"Main title\", \"type\": \"text\" } ], \"type\": \"paragraph\" }, { \"content\": [ { \"content\": [ { \"content\": [ { \"text\": \"Abcde\", \"type\": \"text\" }, { \"type\": \"hardBreak\" }, { \"text\": \"This is a sentence.\", \"type\": \"text\" } ], \"type\": \"paragraph\" } ], \"type\": \"listItem\" } ] } ]" ; "text" )

Sample output:

"Main title¶Abcde¶This is a sentence."

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

// ExtractAllTextValuesForKey ( json ; key ) 
While ( 
	[
		string = JSONFormatElements ( json ) ;
		searchTerm = Quote ( key ) & " : \"" ;
		searchTermLength = Length ( searchTerm ) ;
		result = "" ;
		termsToFind = PatternCount ( string ; searchTerm ) ;
		term = 1
	] ;

	term <= termsToFind;

	[
		nextTermStart = Position ( string ; searchTerm ; 1 ; term ) + searchTermLength ;
		nextTermEnd = Position ( string ; "\"" ; nextTermStart ; 1 ) ;
		result = List ( result ; Middle ( string ; nextTermStart ; nextTermEnd - nextTermStart )) ;
		term = term + 1
	] ;
	result
)

This function uses a while to pullout the text values for a give key, at whatever level the key appears.

Comments

		Kyle Williams, Augusto Digital Jan 13, 2021
Your sample input shows you are using this function "ExtractAllAtomicValuesForKey".. but your function's name is "ExtractAllTextValuesForKey". Not sure where "AtomicValues" comes in? This sounds like an interesting function, thanks for sharing.

		Richard Dyce, Dyce & Sons Ltd. Jan 14, 2021
Fixed :-)

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

ExtractAllTextValuesForKey ( json ; key )

Comments

Support this website.

Support this website.