AnsweredAssumed Answered

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

Question asked by saigopaldas on Jul 22, 2015
Latest reply on Aug 16, 2015 by J.M.Schomburg

Title

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

Post

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

 

 

 

Outcomes