Bookshelf Home | Contents | Index | Search | PDF |
Siebel VB Language Reference > Siebel VB Language Reference >
Right Function
This standard VB function returns a portion of a string beginning at the end of the string.
Syntax
Right[$](string, length)
Argument Description string A string or string expression containing the characters to copy length The number of characters to copy
Returns
A string of length length copied from the end of string.
Usage
If length is greater than the length of string, Right returns the whole string.
Right accepts any type of string, including numeric values, and converts the input value to a string.
The dollar sign ($) in the function name is optional. If it is included, the return type is string. Otherwise the function returns a variant of vartype 8 (string). If the value of string is NULL, a variant of vartype 1 (Null) is returned.
Example
This example checks for the extension .bmp in a filename entered by a user and activates the Paintbrush application if the file is found. Note that this uses the Option Compare Text statement to accept either uppercase or lowercase letters for the filename extension.
Option Compare Text
Sub Button_Click
Dim filename as String
Dim x
filename ="d:\temp\picture.BMP"
extension = Right(filename,3)
If extension = "BMP" then
x = Shell("PBRUSH.EXE",1)
Sendkeys "%FO" & filename & "{Enter}", 1
Else
End If
End SubSee Also
InStr Function
Left Function
Len Function
LTrim Function
Mid Function
Mid Function
RTrim Function
Trim Function
Bookshelf Home | Contents | Index | Search | PDF |
Siebel VB Language Reference Published: 18 June 2003 |