JSONArray_SearchForValueInKey ( inputArray ; matchKey ; searchValue )

A While() loop that searches an array for a string within a specific key's value in each element. Returns an array of indexes where patternCount > 0. Requires FM21+

Be the first to rate this function Log in to vote

David A Sullivan - Show more from this author
Mandelbrot LLC
http://mandelbrotllc.com

Sample input:

"[{\"foo\":\"bar\"}, {\"herp\":\"derp\", \"foo\":\"barrio\"}, {\"foo\":\"bat\"} ]" , "foo" ; "bar"

Sample output:

[0,1]

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

/*
A While() loop that searches an array for a string within a specific key's value in each element. Returns an array of indexes where patternCount > 0.  Requires FM21+

2024-09-13 by sully@mandelbrotllc.com
*/

While (

  [
    array = inputArray ;
    key = matchKey ;
    value = searchValue ;
    objCount = ValueCount ( JSONListKeys ( array ; "" ) ) ;
    i = 0 ; 
    matchArray = "" ;
    currentValue = "" 
  ] ; 

  i < objCount ;

  [
    currentValue = JSONGetElement ( array ; "[" & i & "]." & key ) ;
    matchArray = If ( PatternCount ( currentValue ; value ) > 0 ; JSONSetElement ( matchArray ; "[+]" ; GetAsText ( i ) ; 2 ) ; matchArray ) ;
    i = i + 1 
  ] ; 

  matchArray

)

Sometimes we get arrays of objects where we need to search for a partial value in a specific key inside of each object.

Comments

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

JSONArray_SearchForValueInKey ( inputArray ; matchKey ; searchValue )

Comments

Support this website.

Support this website.