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
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.