Using VBScript Functions

Not all functions are carried over to VBScript, just like not all of the statements are carried over. A complete list of functions available in VBScript is shown in Table 13.6.

Table 13.6: Functions Available in VBScript

Function	Description
Abs	Returns the absolute value of a number
Array	Returns a variant containing an array with the specified values
Asc/AscB/AscW	Returns the ASCII value of a character
Atn	Returns the arctangent of the argument
Chr/ChrB/ChrW	Returns a character for a specific ASCII value
Cbool	Converts a value to Boolean
Cbyte	Converts a value to Byte
Ccur	Converts a value to Currency
Cdate	Converts a value to Date
CDbl	Converts a value to Double
Cint	Converts a value to Integer
CLng	Converts a value to Long
Cos	Returns the cosine of the argument
CreateObject	Creates a new instance of the specified object
CSng	Converts a value to Single
Date	Returns the current date
DateSerial	Converts month, day, and year values to a Date value
DateValue	Returns a date part of a Date value
Exp	Returns the exponential of the argument
Filter	Returns a string array that meets the specified filter criteria
Fix	Returns the integer part of a number (Fix (1.2) = 1 and Fix(-1.2) = -1)
FormatCurrency	Formats a value as currency
FormatDateTime	Formats a value as a date or time
FormatNumber	Formats a number
FormatPercent	Formats a number as a percentage
GetObject	Returns a reference to an automation object
Hex	Returns a string containing the hexadecimal value of a number
InputBox	Displays a dialog box with a prompt for an input value
InStr/InStrB	Returns the starting position of the specified substring
InStrRev	Similar to InStr but starts at the end of the string.
Int	Returns an integer part of a number. (Fix (1.2) = 1 and Fix (-1.2) = -2)
IsArray	Returns True if the argument is an array
IsDate	Returns True if the argument contains a valid Date value
IsEmpty	Returns True if the argument has been initialized
IsNull	Returns True if the argument contains valid data
IsNumeric	Returns True if the argument contains a valid number
IsObject	Returns True if the argument contains an object
Join	Joins together a series of strings (opposite of Split)
Lcase	Converts a string to lowercase characters
Left/LeftB	Returns the leftmost part of a string or byte array
Len/LenB	Returns the length of a string or byte array
LoadPicture	Loads a picture object
Log	Returns the log of the argument
LTrim	Removes leading spaces from a string
Mid/MidB	Returns a substring from the middle of a string or byte array
MsgBox	Displays a dialog box with a message
Oct	Returns a string containing the octal value of a number
Replace	Replaces one substring with another substring the specified number of times
RGB	Returns a color based on values for red, green, and blue
Right/RightB	Returns the rightmost part of a string or byte array
Rnd	Returns the next random number from the random-number generator
Round	Rounds a value to the specified number of decimal places
Rtrim	Removes trailing spaces from a string
Sgn	Returns –1 if the argument is negative, 0 if it’s zero, +1 if it’s positive
Sin	Returns the sine of the argument
Space	Fills a string with the specified number of spaces
Split	Breaks apart a string into multiple strings based on a substring (opposite of Join)
Sqr	Returns the square root of the argument
StrComp	Compares strings
String	Fills a string with a specified character the specified number of times
StrReverse	Reverses the order of the characters in the string
Tan	Returns the tangent of the argument
Time	Returns the current time
TimeSerial	Converts hour, minute, and second values to a Date value
TimeValue	Returns the time part of a Date value
Trim	Removes leading and trailing spaces from a string
TypeName	Returns a string containing the name of the type of variable
VarType	Returns an integer containing the type of variable

© 1998 SYBEX Inc. All rights reserved.