PCSPX ( Variables )

Test the contents of script parameter.

Average rating: 4.3 (30 votes) Log in to vote

Kevin Kurpe - Show more from this author

Sample input:

Example 1
SP = "Create, Customer, Record"

PCSPX ("Create, Customer, Record")

Example 2
SP = "132 Select, Customer, Record"

Case (
PCSPX ("Select, Customer, Record") ; "Select" ; "Error" )

Sample output:

1

"Select"

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

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
// Date: 3/23/2009

// To debug, use this --> "N="&N&"V="&V&"T="&T <-- in the zero's place on the "Error" line.

This custom function allows you to test the script parameter for multiple values. I usually use this custom function to trigger certain portions of a script. For example, when a script is separated by IFs and ELSEIFs I can send a script parameter to the script that triggers the first portion of the script, but not the second or third. I have found it to be extremely helpful when working with scripts!

NOTE: This custom function is DEPENDENT ON MY OTHER CUSTOM FUNCTION: PCSP. To use this custom function, you must also have the other.

Kevin Kurpe

Comments

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

PCSPX ( Variables )

Comments

Support this website.

Support this website.