ArGa_FilterListOperator

To filter a list in a new one using comparison operators.

Be the first to rate this function Log in to vote

Arnaldo Gaudenzi - Show more from this author

Sample input:

ArGa_FilterListOperator ( "1¶2¶3¶4" ; "FT" ; "2" ; "3" )

Sample output:

2
3

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

/*
inList		original values
operator	EQ NE GT LT GE LE FT(from to)
parm1		filter value
parm2		only for FT operator

Translated from Italian: check for correct function names
*/

Let ( [ 
$fxIdx = If ( $fxIdx < 1 ; 1 ; $fxIdx + 1 ) ; 
string = GetValue ( inList ; $fxIdx ) ; 
$fxOutList = $fxOutList & 
	Case ( operator = "EQ" and string = parm1 ; string & "¶" ; 
		operator = "NE" and string ≠ parm1 ; string & "¶" ; 
		operator = "GT" and string > parm1 ; string & "¶" ; 
		operator = "LT" and string < parm1 ; string & "¶" ; 
		operator = "GE" and string ≥ parm1 ; string & "¶" ; 
		operator = "LE" and string ≤ parm1 ; string & "¶" ; 
		operator = "FT" and string ≥ parm1 and string ≤ parm2 ; string & "¶" ; 
		"" ) ] ; 

If ( $fxIdx + 1 > ValueCount ( inList ) ; 
	Let ( [ outList = $fxOutList ; 
		$fxOutList = "" ; 
		$fxIdx = "" ] ; 
		outList ) ; 
	ArGa_FilterListOperator ( inList ; operator ; parm1 ; parm2 ) )
)

Translated from Italian: check for correct function names and that local variable names are not used elsewhere

Comments

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

ArGa_FilterListOperator

Comments

Support this website.

Support this website.