Title: String manipulation
I
wrote a PL/SQL package with functions you can use for this. Find it
at http://www.smdi.com/employee/johnf/list.pks
and http://www.smdi.com/employee/johnf/list.pkb.
I wrote it so that only the first call parses the string. Subsequent
calls use the already
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))
t
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
fick 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: The string is: mystr1~mystr2~mystr3
Here is the code so far
se respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: 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 s
27;mystr1~mystr2~mystr3','~',1,1)) )
W_SECOND,
substr('mystr1~mystr2~mystr3',instr('mystr1~mystr2~mystr3','~',1,2)+1,length('mystr1~mystr2~mystr3'))
W_THIRD
FROM dual;
-Original Message-From: Stefick Rona
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,'~',