Show only filename from a path String

[noccy]

Hello!

In a table I have a a field that contains a Path As String.

In the field next to the path (In the query) I want only the filename to show.


Path: c:\MyFiles\Myfile.txt

Filename: Myfile.txt

How can I make this happen?

tnx

noccy

 

[namliam]

?mid("C:\testing some dir\Myfile.txt",instrrev("C:\testing some dir\Myfile.txt","\")+1)
Myfile.txt

?Left("C:\testing some dir\Myfile.txt",instrrev("C:\testing some dir\Myfile.txt","\")-1)
C:\testing some dir

?Left("C:\test\Myfile.txt",instr("C:\test\Myfile.txt","\"))
C:\

Regards

The Mailman

 

[noccy]

tnx m8