Oracle SQL regexp_substr programming issue

Question

Can anyone help me solve this? I'm a bit of a newbie in programming and I'm looking at using REGEXP_SUBSTR in my query. I have a large file and I need to use only certain parts.

I want to convert this: Stuart, Martin E ([email protected]) to this: [email protected]

I'm using regexp_substr and have got it to display everything apart but I have an annoying bracket on the end of the email address I need to get rid of. Can anyone help please?

SELECT regexp_substr ('Stuart, Martin G ([email protected])', '[^("]+',1,2)
FROM dual;

REGEXP_SUBSTR('STUART,MARTING(
------------------------------
[email protected])

Multisync · Accepted Answer · 2014-12-03 20:47:48Z

1

select regexp_substr ('Stuart, Martin G ([email protected])', '[^)("]+',1,2) from dual;

Just add the closing bracket inside [^]

answered Dec 3, 2014 at 20:47

Multisync

8,8271 gold badge20 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sql_dummy · Accepted Answer · 2016-02-28 07:30:58Z

0

 select regexp_substr ('Stuart, Martin G ([email protected])', '[^()]+',1,2) from dual;

works fine. And why are using the literal " in the expression.

answered Feb 28, 2016 at 7:30

sql_dummy

78310 silver badges26 bronze badges

Collectives™ on Stack Overflow

Oracle SQL regexp_substr programming issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related