finding last occurrence in a string

[petela]

Hi,

I know how to find the first occurrence of a character in a string using the VB
InStr function. How do I find the last occurrence of a character in a string? Here is the string I want to manipulate:

C:\Inetpub\wwwroot\greatnorthwest\web door gallery\entry and exterior\Entry w French side litesThumb.jpg

I want to find the position of the last occurrence of "\" in the string, and then trim everything to the left of it so that I the string is reduced to:

Entry w French side litesThumb.jpg.

How would I go about accomplishing this task? I have many more of these strings to manipulate, all contiaining different numbers of the "\" character, so I need to be able to work from right to left.

Thanks,
petela

[glenngv]

Use InStrRev() (Instr Reverse) function.

[petela]

Thanks. That should work. I'll give it a try.

[petela]

It works like a charm. Thanks again.

petela