Brian Dunning's FileMaker Custom Functions

ValueIndex ( valueList , valueString , matchCase , occurrence )

Returns the index/position of the matching valueString in the valueList. Returns 0 if not found.

  Be the first to rate this function Log in to vote

Lewis Lorenz   Lewis Lorenz - Show more from this author
Lorenz Companies
http://www.LorenzCom.com

Share on Facebook Share on Twitter

  Sample input:
ValueIndex ("Alpha¶Bravo¶Charlie¶Echo", "charlie", False, 1)
  Sample output:
3

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

ValueIndex ( valueList , valueString , matchCase , occurrence )

Returns the index/position of the matching valueString in the valueList. Returns 0 if not found.
Require case-sensitive searching by passing a boolean through matchCase.
Search for specific valueString occurrence. Also, a negative occurrence number causes backward search from the end of the valueList.

NOTICE: Requires FileMaker 18+

 

Comments

Michael Horak   Michael Horak, *COMMENT Visual Realisation
May 19, 2023
Compare: https://www.briandunning.com/cf/2607
 

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: