Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Introduction to regular expressions ...
Comments
-
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 -
And, as I mentioned in another thread, HJR's www.dizwell.com is another good option.
-
-
Hi CD,
Too Good..
best regards
Taj -
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.
-
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. -
Hi CD,
Excellent!
Aman.... -
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 [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 -
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. -
This discussion has been closed.