Skip to Main Content

Oracle Forms

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!

How to get only the filename and extension for a text item?

wyfwongNov 12 2007 — edited Nov 13 2007
Suppose there is a non-database text item called :myfilename

:myfilename := 'C:\SomeFolder\SomePath\myfile.doc';

I would like to get the file name only without the full path,
i.e. myfile.doc
and the file extension, i.e. 'doc', 'bat', 'java', 'xhtml' etc., i.e. the last few chars from the right to the period.

Any help is welcome.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2007
Added on Nov 12 2007
3 comments
518 views