Select data prior to a character in a row?
From: DP <dxpesse_at_gmail.com>
Date: Thu, 3 Jan 2008 11:38:12 -0800 (PST)
Message-ID: <9fc2721e-cc19-45d4-9088-b3bf7625219c@i12g2000prf.googlegroups.com>
pr04(droid) : DAQUINT
pr04(droid) : DBSNMP
Date: Thu, 3 Jan 2008 11:38:12 -0800 (PST)
Message-ID: <9fc2721e-cc19-45d4-9088-b3bf7625219c@i12g2000prf.googlegroups.com>
Our CMDB database (vendor supplied) stores information in a
singlevarchar2 field.
The DATA:
Name
MPORTWEB03(MPORTWEB03) : msdb MPORTWEB03(MPORTWEB03) : pubs MPORTWEB03(MPORTWEB03) : tempdb pr04(droid) : DAFRANZ pr04(droid) : DAMOLSO
pr04(droid) : DAQUINT
pr04(droid) : DBSNMP
First SQL
I can select the data after the : withselect substr(name,instr(name,': ')+2,length(name)) from table;
msdb
pubs
tempdb
DAFRANZ
DAMOLSO
DAQUINT
DBSNMP
What I can't figure out is how to select data up to or before the
first open paran.
I have tried RTIRM with no luck.
Any Help you can give me would be greatly appreciated. Thanks,
Dennis Received on Thu Jan 03 2008 - 13:38:12 CST