IndexOf ( searchValue ; listOfValues )

Returns the valueNumber of each occurrence of searchValue in listOfValues.

Be the first to rate this function Log in to vote

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

IndexOf ( "green" ; "red¶green¶blue¶white¶green¶red¶black¶green¶blue¶orange" )

Sample output:

2
5
8

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

/*
IndexOf function

Author
*COMMENT Visual Realisation

Format
IndexOf ( searchValue ; listOfValues )

Parameters
searchValue - any text expression or text field
listOfValues - a list of carriage return-delimited values

Data type returned
text

Description
Returns the valueNumber of searchValue in listOfValues. Each occurence is listed as an individual value.

August 15, 2022

Modified February 22, 2024 to fix an issue with consecutive occurences of searchValue.
*/

While ( [
occurrences = ValueCount ( FilterValues ( listOfValues ; searchValue ) ) ;
adjList = ¶ & Substitute ( listOfValues & ¶ ; ¶ ; Char ( 3 ) & ¶ ) ;
result = "" 
] ;
occurrences ;
[
index = ValueCount ( Left ( adjList ; Position ( adjList ; ¶ & searchValue & Char ( 3 ) ; 1 ; occurrences ) ) ) ; 
result = List ( index ; result ) ;
occurrences = occurrences - 1
] ;
result
)

Returns the valueNumber of searchValue in listOfValues. Each occurence is listed as an individual value.

Comments

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

IndexOf ( searchValue ; listOfValues )

Comments

Support this website.

Support this website.