[RESOLVED] Parsing data

Hi everyone,

I have a variable "Filepath" that contains (depending what I am opening) different file paths. For example,

C:\MyFolder\files\test.txt

How do i strip out the above bolded text? The file names differ in size so I am assuming it all hinges around the last "\"?

Any help is appreciated. Thanks!

VB Code:

Dim sPath As String
    sPath = "C:\MyFolder\files\test.txt"
    Debug.Print Left$(sPath, InStrRev(sPath, "\")) ' C:\MyFolder\files\
    Debug.Print Mid$(sPath, InStrRev(sPath, "\") + 1) ' test.txt

VB Code:

sFilename = "C:\MyFolder\files\test.txt"
    Debug.Print Mid(sFilename, InStrRev(sFilename, "\") + 1)

Edit--
bushmobile :eek2:

Is there a way to strip the ".txt" out of it as well?

VB Code:

sPath = "test.txt"
Debug.Print Left$(sPath, InStrRev(sPath, ".") - 1)

I tried plugging that code in and it doesn't seem to be working correct.

It outputs "C:\D"

yeah - there were some typos i've edited the post #5.

you'll notice i haven't put them together - one gets the name then the other removes the extension - you can figure out how to put them together ;)

Thank you Bush! It is working beautifully. Much appreciated! :D