4 Replies Latest reply on Aug 16, 2015 3:22 AM by J.M.Schomburg

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

    saigopaldas

      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