ListPosition ( InList ; InValue )

Find position of InValue in InList. Not recursive.

Be the first to rate this function Log in to vote

Richard DeShong - Show more from this author
Logic Tools
http://logictools.com

Sample input:

ListPosition ( "A¶B¶C¶D" ; "B" )

Sample output:

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

Case(
   InList = "Empty"  or  IsEmpty( InList ) ; 0 ;
   InValue = "Empty"  or  IsEmpty( InValue ) ; 0 ;
   Let([
      pListp = "¶" & InList & "¶" ;
      pValuep = "¶" & InValue & "¶" ;
      vPos = Position( pListp ; pValuep ; 1 ; 1 )
   ];
      PatternCount( Left( pListp ; vPos ) ; "¶" )
   )
)
// Find position of InValue in InList.

Given a return delimited list of values, InList, returns the position in the list of a given value, InValue.
Notes:
Only returns the first position of the value;
It does not return additional positions if the value is in the list more than once.

I test for = "Empty" because I use the function SetVar() when setting variables;
SetVar() sets the variable to "Empty" if there is no value.

Comments

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

ListPosition ( InList ; InValue )

Comments

Support this website.

Support this website.