every second number in a string

Discussion created by lselsick on Jan 10, 2013
Latest reply on Jan 10, 2013 by 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