Trick to find the value position in a list for a given string

[saigopaldas]

Hi

Here is the function which will give the value position in a list.

 

ValueCount ( Left ( $ItemList ;Position (  "¶"& $ItemList & "¶" ; "¶" & $SearchString & "¶" ; 1 ; 1 )  + Length ( $SearchString ))  )

 

Example,

$ItemList = "1¶2¶14¶5¶222¶12¶22¶42¶11¶23¶44"

$SearchString = "22"

 

Result = 7

[comment]

This part is unnecessary;

+ Length ( $SearchString )

And so are quotes around a single ¶.

Edited July 23, 2015 by comment

[eos]

Here is the function which will give the value position in a list.ValueCount ( Left ( $ItemList ;Position (  "¶"& $ItemList & "¶" ; "¶" & $SearchString & "¶" ; 1 ; 1 )  + Length ( $SearchString ))  )

Present the calculation with generic argument names rather than $variables and it becomes a handy Custom Function:

ItemIndexPositionInList ( theItem ; theList ) =

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

[Lee Smith]

Speaking of Custom Functions, will this one do? 

ListPosition ( ListValues ; SearchValue )