If input like this
as input- abcdxyz@gmail.com & pqrstuv@yahoo.com
and somebody want output like
as output- abcdxyz & pqrstuv
How can I do this using Oracle?
Asked
Active
Viewed 1,080 times
0
a_horse_with_no_name
- 497,550
- 91
- 775
- 843
-
https://stackoverflow.com/questions/3710589/is-there-a-function-to-split-a-string-in-pl-sql – George Sharvadze May 31 '17 at 11:45
2 Answers
2
For your case this will do the job:
select regexp_replace('abcdxyz@gmail.com & pqrstuv@yahoo.com','@[a-zA-z0-9.]*','') from dual;
It is based on asumption that domain name contains only digits and a-z chars.
Kacper
- 4,853
- 2
- 17
- 33
0
If you know all of the possible email addresses (not likely nor robust), you can use the TRIM function:
http://docs.oracle.com/javadb/10.8.3.0/ref/rreftrimfunc.html
More likely, you'll write your own that "rolls" the characters one at a time until it hits the delimiter. A shortish example to this is here (in the split function of the longer example in the accepted answer):
Is there a function to split a string in PL/SQL?
A more complex example and discussion on performance is here:
-
The first link is **not** for the Oracle database but for "JavaDB" aka "Apache Derby". – a_horse_with_no_name Jun 06 '18 at 14:51