[mailto:[EMAIL PROTECTED] Sent: Monday,
January 26, 2004 3:29 PMTo: Multiple recipients of list
ORACLE-LSubject: String manipulation
I'm trying to separate a string into 3
values: The string is: mystr1~mystr2~mystr3
Here is the code so far: 1 select
substr(subject,1,instr
On 01/26/2004 06:29:26 PM, Stefick Ronald S Contr ESC/HRIDA wrote:
I'm trying to separate a string into 3 values:
The string is:
mystr1~mystr2~mystr3
There is trivial, non-PL/SQL solution based on the split
function. To see more, type perldoc -f split and you should
see the light.
--
Please see
Title: String manipulation
select
substr(subject,1,instr(subject,'~')-1) first,
substr(subject,instr(subject,'~')+1,
instr(subject,'~',1,2)-(instr(subject,'~'))-1) second,
substr(subject,instr(subject,'~',1,2)+1,length(subject))
third
from
test_table
where
test_column=1700455
/
Ray
Title: String manipulation
I
wrote a PL/SQL package with functions you can use for this. Find it
athttp://www.smdi.com/employee/johnf/list.pks
andhttp://www.smdi.com/employee/johnf/list.pkb.
I wrote it so that only the first call parses the string. Subsequent
calls use the already parsed
Title: String manipulation
I'm trying to separate a string into 3 values:
The string is:
mystr1~mystr2~mystr3
Here is the code so far:
1 select substr(subject,1,instr(subject,'~')-1) first,
2 substr(subject,instr(subject,'~')+1, instr(subject,'~',1,2)-1) second,
3 substr(subject,instr
tr2~mystr3'))
W_THIRD
FROM dual;
-Original Message-From: Stefick Ronald S
Contr ESC/HRIDA [mailto:[EMAIL PROTECTED] Sent:
Monday, January 26, 2004 3:29 PMTo: Multiple recipients of list
ORACLE-LSubject: String manipulation
I'm trying to separate a string into 3
values:
dual
/
HTH
Jared
Stefick Ronald S Contr ESC/HRIDA [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/26/2004 03:29 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:String manipulation
I'm trying to separate