Brian Dunning's FileMaker Custom Functions

PositionValues ( text ; searchValue ; occurrence )

Return value position (line number) in list of all occurrences of searchValue

  Average rating: 4.1 (40 votes) Log in to vote

Bruce Robertson   Bruce Robertson

Share on Facebook Share on Twitter

  Sample input:
positionValues( "A¶B¶A¶C¶D"; "A¶D"; 1)
  Sample output:
1
3
5

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

Multi-value version of the positionValue function. Return the line number of all items in a list where the item = searchValue. Usually you will want to enter 1 for occurrence to find all values. If you enter a number other than one, and your searchValue is in the form of a list, the offset will only be honored for the first item in the list.

 

Comments

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.

Under construction. Email me your wish list for improvements.