bBox_EvaluateList
bBox_EvaluateList( values; expression {; delimiter} )Parameters:
values: delimited list of string values
expression: an expression in same form as FileMaker's native Evaluate function
delimiter: string to use as a delimiter, defaulting to a return characterResult:
text resultError:
noneScript Step:
none
––––––––––
First appeared in: 0.70
Examples in demo file: 3
Compatibility: Client, macOS, Server, Ubuntu, WebDirect, WPE
––––––––––
For each value supplied, apply the given expression and append it to the function's result. This is similar to how a list comprehension works in Python, and a way of doing looping in a FileMaker calculation.
There are two variables that will be preset when the expression is evaluated. $i will be set to the current iteration number, starting at 1, and incrementing for every value. $v will be set to the current value in list (similar to the statement $values [$i], where $values is an array of strings). For this to work there is some special handling of quote characters, but this will be invisible to your expression.
There is a special case for the delimiter value. If you pass a null string (i.e., "") as the delimiter, each character in the values parameter will be treated as a separate value. This expression would strip all upper-case characters from the values parameter:
bBox_EvaluateList (
"some Characters to Test with";
"If (Code ($v) < Code (\"A\") or Code ($v) > Code (\"Z\"); $v; \"\")";
""
)
––––––––––