C cheer Registered User. Local time Tomorrow, 03:12 Joined Oct 30, 2009 Messages 222 Jan 19, 2012 #1 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
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
J JANR Registered User. Local time Today, 21:12 Joined Jan 21, 2009 Messages 1,623 Jan 19, 2012 #2 Mid([Field],InstrRev([Field],"\")+1) JR