Isolate from string (1 Viewer)

C

Catalina

Registered User.

Local time

Today, 13:31

Joined

Feb 9, 2005

Messages

462

• May 16, 2013

• #1

D:\Databases\MovieDB\Images\MyMovie.jpg

D:\Databases\MovieDB\Test\Images\AnotherMovie.jpg

I'm trying to isolate the part in red. I played with Mid and Instr and still can't get it .
All suggestions how to get it done will be appreciated.

Catalina

 

D

DJkarl

Registered User.

Local time

Today, 15:31

Joined

Mar 16, 2007

Messages

1,028

• May 16, 2013

• #2

Code:Copy to clipboard

Function ParsePart(strVal As String) As String

ParsePart = Mid(strVal, InStr(1, strVal, "\") + 1, InStrRev(strVal, "\") - (InStr(1, strVal, "\")))

End Function

 

C

Catalina

Registered User.

Local time

Today, 13:31

Joined

Feb 9, 2005

Messages

462

• May 16, 2013

• #3

Works great DJkarl.

Thanks.

Catalina