How to extract a file name from a path string?

cheer

Registered User.
Local time
Tomorrow, 03:12
Joined
Oct 30, 2009
Messages
222
Given a string c:\ABC\CDE\TEST.pdf .

Any suggestion to use mid, instr and etc to extract the string above to obtain the file name as TEST.pdf
 
Mid([Field],InstrRev([Field],"\")+1)

JR
 

Users who are viewing this thread

Back
Top Bottom