List.IndexOfFirstValueMatching

Finds index of first value matching value.

Parameters

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"
Mode	Available in MBS FileMaker Plugin 10.3 or newer. Pass 1 for numeric comparison. Default is 0 for text comparison.	0	Optional
StartRow	Available in MBS FileMaker Plugin 14.0 or newer. The row to start at. Default is 0.	0	Optional

Result

Returns number or error.

Description

Examples

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
)

See also

• List.GetValue
• Matrix.IndexOfFirstValueMatching
• QuickList.IndexOfFirstValueMatching

Release notes

• Version 10.4
  • Added prefix/postfix operator for List.IndexOfFirstValueMatching, QuickList.IndexOfFirstValueMatching, List.CountValuesMatching and QuickList.CountValuesMatching.
• Version 10.3
  • Added numeric mode for List.CountValuesMatching, List.IndexOfFirstValueMatching, QuickList.CountValuesMatching and QuickList.IndexOfFirstValueMatching functions.
• Version 10.2
  • Added List.CountValuesMatching, List.IndexOfFirstValueMatching, QuickList.CountValuesMatching and QuickList.IndexOfFirstValueMatching functions.

Blog Entries

• MBS FileMaker Plugin, version 10.4pr7
• MBS FileMaker Plugin, version 10.3pr6
• News about the MBS FileMaker Plugin 10.2
• MBS FileMaker Plugin, version 10.2pr2

This function checks for a license.

Created 5th April 2020, last changed 21st November 2023

List.HasValue - List.InsertValue