Home » SQL & PL/SQL » SQL & PL/SQL » Extracting Number from an Alphanumeric string
Extracting Number from an Alphanumeric string [message #40326] Fri, 27 September 2002 13:32 Go to next message
Bhagwan Singh
Messages: 23
Registered: December 2001
Junior Member
Hi,
Iam currently looping a cursor which gives me a record like(It is stored this way in the table which Iam looping through):

Input :

'abcd Z123''34 bsm'
'avsg Z''234''56 ght'
'ght Z34''56''67 ghtsu'
'absde Z897''456 j'

I want to create a generic procedure which will read this record and give me an output as under with Z no as:

Output:
Z12334
Z23456
Z345667
Z897456
Can someone help me with this problem?
please email me the stored procedure asap.

Matter Urgent.
regards,

my output should be

Report message to a moderator

Re: Extracting Number from an Alphanumeric string [message #40327 is a reply to message #40326] Fri, 27 September 2002 13:42 Go to previous messageGo to next message
Mrinal Hazarika
Messages: 3
Registered: September 2002
Junior Member
Try with this

select replace(translate ( 'aabaZgjgKL2y3y222','abcdefghijklmnopqrstuvwxyz','a'),'a','') from dual;

Report message to a moderator

Re: Extracting Number from an Alphanumeric string [message #40331 is a reply to message #40326] Fri, 27 September 2002 22:21 Go to previous message
Srinivas
Messages: 138
Registered: June 2000
Senior Member
select translate ('abcd Z123"34 bsm','zabcdefghijklmnopqrstuvwxyz" ','a')from dual;

Srinivas

Report message to a moderator

Previous Topic: DDL Through stored procedures plz. help
Next Topic: how to find the # of workings days
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 15:25:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.