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