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 help to get filename and extension

UtsavAug 1 2017 — edited Aug 2 2017

I've a filename column, I want to extract its name and extensions so that another logic could be apply over it.

Since, datavolumne is high which is why I am choosing regexp solution over the generic sql function

Sample Data:   

Sample.file.07.mar.2017.pdf

File.without.its.extension

Expected output:        

_________________________________________

Name_only                  |                      Extension

_________________________________________

Sample.file.07.mar.2017               |                    pdf

File.without.its.extension                |                   

_________________________________________
This post has been answered by Paulzip on Aug 1 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2017
Added on Aug 1 2017
9 comments
3,487 views