jrthor2
07-23-2003, 08:08 AM
I am using the following to get the first 3 leters of the file name, but I need to get the file name without the extension, Ex: baseball.gif, I need just baseball. Below is the code I am currently using. This is pulling the name from a lis of files in a directory.
img = (Left(rstFiles.Fields("name").Value, Len(rstFiles.Fields("name").Value) - InStrRev((rstFiles.Fields("name").Value), ".", -1, 1)))
img = (Left(rstFiles.Fields("name").Value, Len(rstFiles.Fields("name").Value) - InStrRev((rstFiles.Fields("name").Value), ".", -1, 1)))