Right Function |
Microsoft.VisualBasic.Strings
Right( string, length )
The string to be processed
The number of characters to return from the right of the string
String
Returns a string containing the rightmost length characters of string
If length is 0, a zero-length string ("") is returned.
If length is greater than the length of string , string is returned.
If length is less than zero or is Nothing , an error is generated.
If string contains a Nothing , Right returns Nothing .
The following function assumes that it is passed either a filename or a complete path and filename, and it returns the filename from the end of the string:
Private Function ParseFileName(strFullPath As String) As String Dim intPos, intStart As Integer Dim strFilename As String intStart = 1 Do intPos = InStr(intStart, strFullPath, "\") If intPos = 0 Then strFilename = Right(strFullPath, _ Len(strFullPath) - inStart + 1) Else intStart = intPos + 1 End If Loop While intPos > 0 ParseFileName = strFilename End Function
Use the Len function to determine the total length of string .
Left Function, Mid Function