C cheer Registered User. Local time Today, 17:37 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, 10:37 Joined Jan 21, 2009 Messages 1,621 Jan 19, 2012 #2 Mid([Field],InstrRev([Field],"\")+1) JR
