Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 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
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 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. -
Aman.... Database Consultant, Author, Trainer World Wide over the WebMember Posts: 22,919 Gold CrownHi 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.