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!

Extract filename with extension

LAVANKVJul 25 2021

Oracle Database 19c
Windows environment.
I have a string for example str1 = 'file1.jpg,file2.JPG-file3.png-file4.jpeg,filename5.PNG'
The string might be comma separated or any other character.
I want to extract the file name from the string as follows:
file1.jpg
file2.JPG
file3.png
file4.jpeg
filename5.PNG
I need the output in PLSQL program.
Thanks

This post has been answered by Frank Kulash on Jul 25 2021

Jump to Answer

Added on Jul 25 2021

7 comments

972 views

1 mention