finding last occurrence in a string
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.