Selecting Odd and even digit values from a string
I would like to know a simple way of selecting the odd and even digits from a string of 48 charaters.
Say I have a string for example '1p1p2p3p4p5p4e3e2e1e' of 20 characters. I want to select the odd digit values '1123454321' and
even digit values 'ppppppeeee'.
I tried using substr('str',1,1) || substr('str',3,1) and so on for odd digit values and similarly for even digit values.
I don't know if there is any simple method other than using the substr.
Expecting the expert comments on this.
Thanks in adv.