3 Replies Latest reply on Jan 10, 2013 7:50 PM by lselsick

    every second number in a string

    lselsick

      good day everyone.

       

      i need to extract every second number from a string of numbers. so the string might read "123456789" and my solution requires "1" in one field, "3" in the next field, "5" in the next field, and so on all the way up to 9.

       

      i can see how to get the left most number (including grabbing several consecutive numbers), and obviously the same for right. but i cannot figure out how to get every second number.

       

      anyone able to give me a pointer?

       

      using veriosn 11, advanced.

       

      many thanks