Getting FileName without the complete path 1

[mlapse]

Hi,

I have a requirement where I would like to get the filename of the input file without the path.

Ex: if the file path returned from GETFILENAME is C:\apps\mercator\example.txt, I want to put example.txt in the output.

How can i do this?

Thanks

 

[mlapse]

I have been able to do this successfully. Thanks a lot !

 

[JuJutsu]

OK, what did you do? There is more than one way to do this.


JuJutsu - Jeff S.
Support Analyst

 

[mlapse]

What I did was:

SUBSTITUTE(GETFILENAME(Filename), GETDIRECTORY(Filename), "")

It worked fine. Is there something I could have done to make it easier.

 

[JEMIAZ]

WORD(GETFILENAME(Filename),"\",-1) works great