VBScript Functions @ One Reference | |
| |
Date/Time Functions | |
CDate: | Converts a valid date and time expression to the variant of subtype Date |
Date: | Returns the current system date |
DateAdd: | Returns a date to which a specified time interval has been added |
DateAdd: | Returns a date to which a specified time interval has been added |
DateDiff: | Returns the number of intervals between two dates |
DatePart: | Returns the specified part of a given date |
DateSerial: | Returns the date for a specified year, month, and day |
DateValue: | Returns a date |
Day: | Returns a number that represents the day of the month (between 1 and 31, inclusive) |
FormatDateTime: | Returns an expression formatted as a date or time |
Hour: | Returns a number that represents the hour of the day (between 0 and 23, inclusive) |
IsDate: | Returns a Boolean value that indicates if the evaluated expression can be converted to a date |
Minute: | Returns a number that represents the minute of the hour (between 0 and 59, inclusive) |
Month: | Returns a number that represents the month of the year (between 1 and 12, inclusive) |
MonthName: | Returns the name of a specified month |
Now: | Returns the current system date and time |
Second: | Returns a number that represents the second of the minute (between 0 and 59, inclusive) |
Time : | Returns the current system time |
Timer: | Returns the number of seconds since 12:00 AM |
TimeSerial: | Returns the time for a specific hour, minute, and second |
TimeValue: | Returns a time |
Weekday: | Returns a number that represents the day of the week (between 1 and 7, inclusive) |
WeekdayName: | Returns the weekday name of a specified day of the week |
Year : | Returns a number that represents the year |
Conversion Functions | |
Asc: | Converts the first letter in a string to ANSI code |
CBool: | Converts an expression to a variant of subtype Boolean |
CByte: | Converts an expression to a variant of subtype Byte |
CCur: | Converts an expression to a variant of subtype Currency |
CDate: | Converts a valid date and time expression to the variant of subtype Date |
CDbl: | Converts an expression to a variant of subtype Double |
Chr: | Converts the specified ANSI code to a character |
CInt: | Converts an expression to a variant of subtype Integer |
CLng : | Converts an expression to a variant of subtype Long |
CSng : | Converts an expression to a variant of subtype Single |
CStr: | Converts an expression to a variant of subtype String |
Hex: | Returns the hexadecimal value of a specified number |
Oct: | Returns the octal value of a specified number |
Format Functions | |
FormatCurrency : | Returns an expression formatted as a currency value |
FormatDateTime: | Returns an expression formatted as a date or time |
FormatNumber: | Returns an expression formatted as a number |
FormatPercent: | Returns an expression formatted as a percentage |
Math Functions | |
Abs: | Returns the absolute value of a specified number |
Atn: | Returns the arctangent of a specified number |
Cos: | Returns the cosine of a specified number (angle) |
Exp: | Returns raised to a power |
Hex: | Returns the hexadecimal value of a specified number |
Int: | Returns the integer part of a specified number |
Fix: | Returns the integer part of a specified number |
Log: | Returns the natural logarithm of a specified number |
Oct: | Returns the octal value of a specified number |
Rnd: | Returns a random number less than 1 but greater or equal to 0 |
Sgn: | Returns an integer that indicates the sign of a specified number |
Sin: | Returns the sine of a specified number (angle) |
Sqr: | Returns the square root of a specified number |
Tan: | Returns the tangent of a specified number (angle) |
Array Functions | |
Array: | Returns a variant containing an array |
Filter : | Returns a zero::based array that contains a subset of a string array based on a filter criteria |
IsArray: | Returns a Boolean value that indicates whether a specified variable is an array |
Join: | Returns a string that consists of a number of substrings in an array |
LBound: | Returns the smallest subscript for the indicated dimension of an array |
Split: | Returns a zero::based, one::dimensional array that contains a specified number of substrings |
UBound: | Returns the largest subscript for the indicated dimension of an array |
String Functions | |
InStr: | Returns the position of the first occurrence of one string within another. The search begins at the first character of the string |
InStrRev: | Returns the position of the first occurrence of one string within another. The search begins at the last character of the string |
LCase: | Converts a specified string to lowercase |
Left: | Returns a specified number of characters from the left side of a string |
Len: | Returns the number of characters in a string |
LTrim: | Removes spaces on the left side of a string |
RTrim: | Removes spaces on the right side of a string |
Trim: | Removes spaces on both the left and the right side of a string |
Mid: | Returns a specified number of characters from a string |
Replace: | Replaces a specified part of a string with another string a specified number of times |
Right : | Returns a specified number of characters from the right side of a string |
Space: | Returns a string that consists of a specified number of spaces |
StrComp: | Compares two strings and returns a value that represents the result of the comparison |
String: | Returns a string that contains a repeating character of a specified length |
StrReverse: | Reverses a string |
UCase: | Converts a specified string to uppercase |
Other Functions | |
CreateObject: | Creates an object of a specified type |
Eval: | Evaluates an expression and returns the result |
GetLocale: | Returns the current locale ID |
GetObject: | Returns a reference to an automation object from a file |
GetRef: | Allows you to connect a VBScript procedure to a DHTML event on your pages |
InputBox: | Displays a dialog box, where the user can write some input and/or click on a button, and returns the contents |
IsEmpty: | Returns a Boolean value that indicates whether a specified variable has been initialized or not |
IsNull : | Returns a Boolean value that indicates whether a specified expression contains no valid data (Null) |
IsNumeric: | Returns a Boolean value that indicates whether a specified expression can be evaluated as a number |
IsObject: | Returns a Boolean value that indicates whether the specified expression is an automation object |
LoadPicture: | Returns a picture object. Available only on 32::bit platforms |
MsgBox: | Displays a message box, waits for the user to click a button, and returns a value that indicates which button the user clicked |
RGB: | Returns a number that represents an RGB color value |
Round: | Rounds a number |
ScriptEngine: | Returns the scripting language in use |
ScriptEngineBuildVersion: | Returns the build version number of the scripting engine in use |
ScriptEngineMajorVersion: | Returns the major version number of the scripting engine in use |
ScriptEngineMinorVersion: | Returns the minor version number of the scripting engine in use |
SetLocale: | Sets the locale ID and returns the previous locale ID |
TypeName : | Returns the subtype of a specified variable |
VarType: | Returns a value that indicates the subtype of a specified variable |
|
Friday, 26 August 2011
QTP - VBScript Functions - One Reference
Friday, 26 August 2011
QTP - VBScript Functions - One Reference
VBScript Functions @ One Reference | |
| |
Date/Time Functions | |
CDate: | Converts a valid date and time expression to the variant of subtype Date |
Date: | Returns the current system date |
DateAdd: | Returns a date to which a specified time interval has been added |
DateAdd: | Returns a date to which a specified time interval has been added |
DateDiff: | Returns the number of intervals between two dates |
DatePart: | Returns the specified part of a given date |
DateSerial: | Returns the date for a specified year, month, and day |
DateValue: | Returns a date |
Day: | Returns a number that represents the day of the month (between 1 and 31, inclusive) |
FormatDateTime: | Returns an expression formatted as a date or time |
Hour: | Returns a number that represents the hour of the day (between 0 and 23, inclusive) |
IsDate: | Returns a Boolean value that indicates if the evaluated expression can be converted to a date |
Minute: | Returns a number that represents the minute of the hour (between 0 and 59, inclusive) |
Month: | Returns a number that represents the month of the year (between 1 and 12, inclusive) |
MonthName: | Returns the name of a specified month |
Now: | Returns the current system date and time |
Second: | Returns a number that represents the second of the minute (between 0 and 59, inclusive) |
Time : | Returns the current system time |
Timer: | Returns the number of seconds since 12:00 AM |
TimeSerial: | Returns the time for a specific hour, minute, and second |
TimeValue: | Returns a time |
Weekday: | Returns a number that represents the day of the week (between 1 and 7, inclusive) |
WeekdayName: | Returns the weekday name of a specified day of the week |
Year : | Returns a number that represents the year |
Conversion Functions | |
Asc: | Converts the first letter in a string to ANSI code |
CBool: | Converts an expression to a variant of subtype Boolean |
CByte: | Converts an expression to a variant of subtype Byte |
CCur: | Converts an expression to a variant of subtype Currency |
CDate: | Converts a valid date and time expression to the variant of subtype Date |
CDbl: | Converts an expression to a variant of subtype Double |
Chr: | Converts the specified ANSI code to a character |
CInt: | Converts an expression to a variant of subtype Integer |
CLng : | Converts an expression to a variant of subtype Long |
CSng : | Converts an expression to a variant of subtype Single |
CStr: | Converts an expression to a variant of subtype String |
Hex: | Returns the hexadecimal value of a specified number |
Oct: | Returns the octal value of a specified number |
Format Functions | |
FormatCurrency : | Returns an expression formatted as a currency value |
FormatDateTime: | Returns an expression formatted as a date or time |
FormatNumber: | Returns an expression formatted as a number |
FormatPercent: | Returns an expression formatted as a percentage |
Math Functions | |
Abs: | Returns the absolute value of a specified number |
Atn: | Returns the arctangent of a specified number |
Cos: | Returns the cosine of a specified number (angle) |
Exp: | Returns raised to a power |
Hex: | Returns the hexadecimal value of a specified number |
Int: | Returns the integer part of a specified number |
Fix: | Returns the integer part of a specified number |
Log: | Returns the natural logarithm of a specified number |
Oct: | Returns the octal value of a specified number |
Rnd: | Returns a random number less than 1 but greater or equal to 0 |
Sgn: | Returns an integer that indicates the sign of a specified number |
Sin: | Returns the sine of a specified number (angle) |
Sqr: | Returns the square root of a specified number |
Tan: | Returns the tangent of a specified number (angle) |
Array Functions | |
Array: | Returns a variant containing an array |
Filter : | Returns a zero::based array that contains a subset of a string array based on a filter criteria |
IsArray: | Returns a Boolean value that indicates whether a specified variable is an array |
Join: | Returns a string that consists of a number of substrings in an array |
LBound: | Returns the smallest subscript for the indicated dimension of an array |
Split: | Returns a zero::based, one::dimensional array that contains a specified number of substrings |
UBound: | Returns the largest subscript for the indicated dimension of an array |
String Functions | |
InStr: | Returns the position of the first occurrence of one string within another. The search begins at the first character of the string |
InStrRev: | Returns the position of the first occurrence of one string within another. The search begins at the last character of the string |
LCase: | Converts a specified string to lowercase |
Left: | Returns a specified number of characters from the left side of a string |
Len: | Returns the number of characters in a string |
LTrim: | Removes spaces on the left side of a string |
RTrim: | Removes spaces on the right side of a string |
Trim: | Removes spaces on both the left and the right side of a string |
Mid: | Returns a specified number of characters from a string |
Replace: | Replaces a specified part of a string with another string a specified number of times |
Right : | Returns a specified number of characters from the right side of a string |
Space: | Returns a string that consists of a specified number of spaces |
StrComp: | Compares two strings and returns a value that represents the result of the comparison |
String: | Returns a string that contains a repeating character of a specified length |
StrReverse: | Reverses a string |
UCase: | Converts a specified string to uppercase |
Other Functions | |
CreateObject: | Creates an object of a specified type |
Eval: | Evaluates an expression and returns the result |
GetLocale: | Returns the current locale ID |
GetObject: | Returns a reference to an automation object from a file |
GetRef: | Allows you to connect a VBScript procedure to a DHTML event on your pages |
InputBox: | Displays a dialog box, where the user can write some input and/or click on a button, and returns the contents |
IsEmpty: | Returns a Boolean value that indicates whether a specified variable has been initialized or not |
IsNull : | Returns a Boolean value that indicates whether a specified expression contains no valid data (Null) |
IsNumeric: | Returns a Boolean value that indicates whether a specified expression can be evaluated as a number |
IsObject: | Returns a Boolean value that indicates whether the specified expression is an automation object |
LoadPicture: | Returns a picture object. Available only on 32::bit platforms |
MsgBox: | Displays a message box, waits for the user to click a button, and returns a value that indicates which button the user clicked |
RGB: | Returns a number that represents an RGB color value |
Round: | Rounds a number |
ScriptEngine: | Returns the scripting language in use |
ScriptEngineBuildVersion: | Returns the build version number of the scripting engine in use |
ScriptEngineMajorVersion: | Returns the major version number of the scripting engine in use |
ScriptEngineMinorVersion: | Returns the minor version number of the scripting engine in use |
SetLocale: | Sets the locale ID and returns the previous locale ID |
TypeName : | Returns the subtype of a specified variable |
VarType: | Returns a value that indicates the subtype of a specified variable |
|
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment