• Home
 · 
• String Manipulation
 · 
• Function to find the last part of string. If you know PATH name you can cut off first part and re

Function to find the last part of string. If you know PATH name you can cut off first part and re

Function to find the last part of string. If you know PATH name you can "cut off" first part and return just FILE name. fileName =

Rate Function to find the last part of string. If you know PATH name you can cut off first part and re

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Dim chrMostRight_tmp As String
Dim nChr, j, Count, chrPlace As Integer

    nChr = Len(strInput)
    
        For j = nChr To 1 Step -1
            chrMostRight_tmp = Left(strInput, j)
            If Right(chrMostRight_tmp, 1) = chrMostRight Then Exit For
            Count = Count + 1
        Next
    
    chrPlace = nChr - (Count - 1)
    strRightPart = Mid$(strInput, chrPlace)

End Function