FileMaker Pro Custom Functions

/* balance( theText; openbracket; closebracket ) Bruce Robertson - Concise Design 6/14/2009 Version 1.01 - corrected error Given text such as JSON formatted text, look for first instance of openbracket then look for instance of closebracket satisfying condition that count of openbracket = count of closebracket Returns all text up to and including identified closebracket Example balance( "((a=b); (1); [ (a,b);(c;d)]); ( 1;3;4)"; "("; ")") => ((a=b); (1); [ (a,b);(c;d)]) */ Case( IsEmpty( theText ); 0 ; Let ( [ $instance = Case( IsEmpty( $instance) ; 1; $instance + 1); L1 = Length( openbracket ); L2 = Length( closebracket ); p1 = Position ( theText; openbracket ; 1 ; 1 ) ; p2 = Position ( theText; closebracket ; 1; $instance ) ; C1 = PatternCount( Left( theText; p2 + L2 -1); openbracket ); C2 = PatternCount( Left( theText; p2 + L2 -1); closebracket ) ]; Case( P1 = 0; Let( $instance = ""; "" ); P2 = 0; Let( $instance = ""; "" ); C1= C2 ; Let( $instance = ""; Left( theText; P2 + L2 -1 ) ) ; Balance( theText; openbracket; closebracket ) )))
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.