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.
Never Ever Give Up!
Click Here to Expand Forum to Full Width