ItemIndexPosition ( Text ; SearchString )
To find the position of a value in a given list
Average rating: 4.2 (31 votes) Log in to vote
|
Saigopal Das Mindfire Solutions http://www.mindfiresolutions.com/ |
Sample input:
ItemIndexPosition ( "1¶2¶14¶5¶222¶12¶22¶42¶11¶23¶44" ; "22" )
Sample output:
7
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This one line function first trims the list upto the search string and then takes the valuecount which will be index position of the searched string.
Text ="1¶2¶14¶5¶222¶12¶22¶42¶11¶23¶44"
SearchString = "22"
Left ( Text ;Position ( ¶ & Text & ¶ ; ¶ & SearchString & ¶ ; 1 ; 1 ))
= "1¶2¶14¶5¶222¶12¶2"
ValueCount ("1¶2¶14¶5¶222¶12¶2" ) = 7
Comments
 |
Tom Fitch Jul 30, 2015 |
|
| Or if you prefer: http://www.briandunning.com/cf/1300 |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.