OffsetInList ( theList ; value )

Returns the item position of value (first instance only) within theList. Returns 0 otherwise.

Average rating: 4.2 (41 votes) Log in to vote

Don Aehl
none
http://nop

Sample input:

OffsetInList ( "abc¶def¶ab¶de¶ab¶d¶a" , "d" )

Sample output:

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

ValueCount ( Left ( theList ; Position ( ¶ & theList & ¶; ¶ & value & ¶ ; 1 ; 1 ) ) )

Returns the item position of value (first instance only) within theList. Returns 0 otherwise.

Comments

		WilliamCB, London Mar 26, 2009
This function fails by returning the value 0 in the scenario where the value is 75AH and theList is 21AH 91AH 75AH 36AH 63AH 130AH 121AH 107AH 42AH 120AH 19AH 101AH 144AH 14AH 116AH 40AH 33AH 133AH 88AH 60AH 45AH 86AH 90AH 67AH 62AH 22AH 138AH 139AH 135AH 100AH 208AH 34AH 132AH 13AH 124AH 128AH 32AH 1AH 117AH 127AH 39AH 59AH 31AH 92AH 118AH 5AH 72AH 65AH 136AH 58AH 110AH

		WilliamCB, London Mar 26, 2009
I recommend the WordPosition custom function instead.

		Don Aehl, Waukesha, WI Apr 17, 2009
WilliamCB, I pasted the data you listed above, but my OffsetInList function returns 3, not 0 as you indicate.

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