alphabets and digits extraction from a string.

kollurianu · Post by **kollurianu** » Fri Apr 18, 2008 3:04 pm

I have following strings

OOAY08-01-2007
MCHTBB01-07-08

I need to seperate into two different strings ,

like OOAY and 08-01-2007
How can i acheive this in parallel job.?
I know in server we can acheive this by using OCONV function for extracting Numeric and Character part..

In parallel job how can it be done...if we need to write a routine..
should it be in C++.Can some give ideas...

Thank you all in advance.

kumar_s · Post by **kumar_s** » Fri Apr 18, 2008 4:18 pm

'Convert' to Numbers to empty strings. And that goes to Sting part.
Find length of this Sting and get the substring from the main string as staring from the string lenght to the total length.

devidotcom · Post by **devidotcom** » Sat Apr 19, 2008 5:07 am

Also if you know that the last field value is a date of length 10 then take a substring to get the second field value

rsomiset · Post by **rsomiset** » Wed Apr 23, 2008 12:56 pm

devidotcom wrote:Also if you know that the last field value is a date of length 10 then take a substring to get the second field value

Hi,
But in the sample data given, the second record has only 8 digits in the date part. So, we cannot get the substring of second field value with this variable length of date.

kollurianu · Post by **kollurianu** » Wed Apr 23, 2008 1:44 pm

Yes you are right Rajesh. I was thinking in similar lines as Kumar suggested.

Thank you all for your responses.