FileMaker Pro Custom Functions

Let ( // This CF compares the Variables against the SP. // If ALL the Variables are found in the SP, the result is a 1. [ // BEGIN the declaration of variables. N = WordCount ( Variables ) ; // The number of variables to check. V = MiddleWords ( Variables ; N ; 1 ) ; // The current variable in question. T = If ( PCSP ( V ) ; "OK" ; "Error" ) // Compare V & SP --> Is there a match? ] ; // END the declaration of variables. Case ( T = "OK" and N > 1 ; // If V was found in SP and the ARE more variables to check... PCSPX ( LeftWords ( Variables ; N - 1 ) ) ; // ...continue checking. T = "OK" and N = 1 ; // If V was found in SP and the are NOT more variables to check... 1 ; // [OK] ALL Variables were found in the SP --> Pass result = 1. 0 ) ) // [Error] One or more Variables were not found in the SP --> Fail Result = 0 // Credit: Kevin Kurpe // Email: Kevin@YourProponent.com // Date: 3/23/2009 // To debug, use this --> "N="&N&"V="&V&"T="&T <-- in the zero's place on the "Error" line.
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.