Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REGEXP_SUBSTR Question

AquaNX4May 23 2014 — edited May 23 2014

Good Day To All:

I have a column in a table that contains file names as such:

EXAMPLE1.05232014.BUSINESS.PDF

EXAMPLE2.05182014.SUPPORT.DOCX

EXAMPLE3.02252014.OPERATIONS.GIF

How do I use the REGEXP_SUBSTR function to extract the file extension?  My desired output for above data would be:

.PDF

.DOCX

.GIF

Please, if there is an easier way to extract the file extension do share, as I have mucho problemos with the REGEXP_SUBSTR command.

SQL DEVELOPER VERSION  Version 3.2.20.09 - Oracle 10g Environment

Thank you so much for your help!

I appreciate the expertise here....
This post has been answered by Frank Kulash on May 23 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2014
Added on May 23 2014
#apex, #data, #function, #query
12 comments
4,259 views