AnsweredAssumed Answered

Need specific position when multiple occurrences

Question asked by heckam10 on Mar 6, 2015
Latest reply on Mar 6, 2015 by heckam10

Title

Need specific position when multiple occurrences

Post

I have a chunk of text in a variable that could contain repeat values. I need to find the position of a specific value.

This is my list obtained using execute sql.

          8mm Projector    25    1    3
          Digital Projector    3095    26    3
          Overhead Projector    30    2    3
          Projector Screen    105    2    3
          Slide Projector    45    1    3

I need it to find the 30 in the 3rd row, not the 30 in the 2nd row.

 

Outcomes