Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
13.5
Statistic
FMM
Blog
Finds index of first value matching value.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
List | 10.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
List | The list to process. | "Hello" ¶ "" ¶ "World" | |
Operator | The compare operator. Can be =, !=, <, >, <=, >=, ≤, ≥, ≠, Prefix or Postfix. |
"≥" | |
Value | The value to compare. | "Test" | Optional |
Mode | Available in MBS FileMaker Plugin 10.3 or newer. Pass 1 for numeric comparison. Default is 0 for text comparison. |
0 | Optional |
Returns number or error.
Find the value =2:
MBS( "List.IndexOfFirstValueMatching"; "1¶2¶3¶4"; "="; 2 )
Example result: 1
Find the value ≥3
MBS( "List.IndexOfFirstValueMatching"; "1¶2¶3¶4"; ">="; 3 )
Example result: 2
Find hello as prefix:
MBS( "List.IndexOfFirstValueMatching"; "test¶hello_123¶audi 34"; "prefix"; "hello" )
Example result: 1
Find next one in a list:
Let(
[
// you have a list
list = "132430¶132433¶132437¶132445¶132447¶132450¶132463¶132464¶132465¶132466¶132468¶132469¶132470¶";
// find a value
index = MBS( "List.IndexOfFirstValueMatching"; list; "="; 132450; 1);
// now pick one after it:
nextValue = MBS( "List.GetValue"; List; index + 1)
];
nextValue
)
This function checks for a license.
Created 5th April 2020, last changed 27th October 2023