Finding the base file name

Question

What the easiest way to find the base filename in progress.

I have:

 /tmp/admin/run/test.txt

and I want:

 test.txt

10.2b

Answer 1

Use the R-INDEX() function to find the right-most "/".

define variable path as character no-undo initial "/tmp/admin/run/test.txt".

display
  path format "x(60)" skip 
  substring( path, r-index( path, "/" ) + 1 ) format "x(60)"
.