Introduction to regular expressions ...

j4john

cd,

Excellent, thankyou very much for sharing your expertise.

Could I please point you to 432368 to get your insight on why I'm having a problem with Apex using a regex that works OK in a non-Apex environment?

Many thanks,

john

245482

And, as I mentioned in another thread, HJR's www.dizwell.com is another good option.

469875

Mohammed Taj

Hi CD,

Too Good..


best regards
Taj

Keith Jamieson

This is just the sort of information I was looking for, and I think you should submit it to oracle magazine. I'm sure they'll like it, but they may ask for some amendments.

cd_2

Thank you. However I'm afraid Oracle Magazine won't take my article because they state that they will only publish articles that haven't been published anywhere else - and posting it here probably counts as publishing.

C.

Aman....

Hi CD,
Excellent!
Aman....

Mahmood Lebbai

I was trying to use regexp_substr function to retrieve the email domain (eg. yahoo.co.in for [email protected])...but all I could get to was

"select regexp_substr('my email is abc[email protected]','@[^[:space:]]*',1,1) str from dual;" -- @yahoo.co.in

I am missing something here....Is there any ways that I could get what I just wanted.....Using trim function to remove the leading '@' is one way....

Can the regular expression do this for this situation?

Thanks.

Edited by: Mahmood Lebbai on Sep 22, 2008 10:40 PM

cd_2

Just some quick answers from my side, with REGEXP_SUBSTR and REGEXP_REPLACE:

WITH t AS (SELECT 'my email is [email protected]' col1
             FROM dual
          )
SELECT t.col1
     , LTRIM(REGEXP_SUBSTR(t.col1, '@[^[:space:]]+'), '@') solution_1
     , REGEXP_REPLACE(t.col1, '@([^[:space:]]+)|.', '\1') solution_2
  FROM t
;    

OL1                        SOLUTION_1                  SOLUTION_2
-------------------------- --------------------------- --------------------
y email is [email protected] yahoo.co.in                 yahoo.co.in

C.

Aketi Jyuuzou

similar threads used for same regex-logic.
700680
705978