extract required data from string

thumati.praveen · Post by **thumati.praveen** » Mon Oct 30, 2006 1:47 am

Hi everybody,
my problem is extract requred data from string like

"12.32.345.23 datastage" this is my string,in this i want to extract some time numeric only(like 12.32.345.23) and some times i want to extract charecters only(like datastage).in server jobs code conversions is their,but in parlell jobs we can not use the ICONV,OCONV functions.

can you privide the solution for this problem.

Thanks,inAdvance.

satishmelinamani · Post by **satishmelinamani** » Mon Oct 30, 2006 3:09 am

Probably you can make use of Basic Transformer in your Parallel Job.

balajisr · Post by **balajisr** » Mon Oct 30, 2006 3:32 am

satishmelinamani wrote:Probably you can make use of Basic Transformer in your Parallel Job.

... if performance is not an issue.

thumati.praveen · Post by **thumati.praveen** » Mon Oct 30, 2006 5:39 am

In transformer their is no function for extracting the numerics from string and extracting the alphabetics from the string.

chulett · Post by **chulett** » Mon Oct 30, 2006 5:46 am

Well... how about How to Extract only number from alphanumeric?

ray.wurlod · Post by **ray.wurlod** » Mon Oct 30, 2006 7:38 am

Please note that 12.32.345.23 would not be counted as numeric in either server or parallel jobs.

DSguru2B · Post by **DSguru2B** » Mon Oct 30, 2006 8:31 am

That was a smart solution that Kumar came up with. It can work for both server and px.

DSXchange

extract required data from string

extract required data from string

Re: extract required data from string

Re: extract required data from string