Common VBScript Functions
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| VarType | Returns an integer code that indicates the subtype of a variable.
🗑
|
||||
| TypeName | Returns the subtype of a variable.
🗑
|
||||
| IsNumeric | Returns a Boolean value indicating whether an expression can be evaluated as a number.
🗑
|
||||
| IsArray | Returns a Boolean value indicating whether a variable is an array.
🗑
|
||||
| IsDate | Returns a Boolean value indicating whether the expression can be converted to a date.
🗑
|
||||
| IsEmpty | Returns a Boolean value indicating whether a variable has been initialized or not.
🗑
|
||||
| IsNull | Returns a Boolean value that indicates whether an expression contains no valid datatype.
🗑
|
||||
| IsObject | Returns a Boolean value indicating whether an expression refers to an Automation object.
🗑
|
||||
| CBool | Converts an expression to a Boolean subtype.
🗑
|
||||
| CByte | Converts an expression to a Byte subtype.
🗑
|
||||
| CCur | Converts an expression to a Currency subtype.
🗑
|
||||
| CDate | Converts an expression to a Date subtype.
🗑
|
||||
| CDbl | Converts an expression to a Double subtype.
🗑
|
||||
| CInt | Converts an expression to a Integer subtype.
🗑
|
||||
| CLng | Converts an expression to a Long subtype.
🗑
|
||||
| CSng | Converts an expression to a Single subtype.
🗑
|
||||
| CStr | Converts an expression to a String subtype.
🗑
|
||||
| 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 percent value with a trailing percent (%) symbol.
🗑
|
||||
| Join | Returns a string created by joining strings stored in an array.
🗑
|
||||
| Filter | Returns a zero-based array containing subset of a string array based on a filter criteria.
🗑
|
||||
| InStr | Returns the numeric position of the first occurrence of one string within another.
🗑
|
||||
| InStrRev | Returns the numeric position of the first occurrence of one string within another starting from the end of the string.
🗑
|
||||
| LCase | Returns a string with all its uppercase letters converted to lowercase letters.
🗑
|
||||
| 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 all the spaces from the left side of a string.
🗑
|
||||
| RTrim | Removes all the spaces from the right side of a string.
🗑
|
||||
| Trim | Removes spaces from both the left and the right sides of a string.
🗑
|
||||
| Mid | Returns a specified number of characters from a string.
🗑
|
||||
| Replace | Returns a string in which a specified sub-string has been replaced with another substring a specified number of times.
🗑
|
||||
| Right | Returns a specified number of characters from the right side of a string.
🗑
|
||||
| Space | Returns a string consisting of the number of defined spaces.
🗑
|
||||
| Split | Returns a zero-based, one-dimensional array that contains a specified number of substrings.
🗑
|
||||
| StrComp | Compares two strings and returns a value indicating the result of the comparison.
🗑
|
||||
| String | Returns a string consisting of character repeated number times.
🗑
|
||||
| StrReverse | Returns a string where the character order has been reversed.
🗑
|
||||
| UCase | Returns string with all its lowercase letters converted to uppercase letters.
🗑
|
||||
| Date | Returns the current system date.
🗑
|
||||
| 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 a date for a specified year, month, and day.
🗑
|
||||
| DateValue | Returns a date.
🗑
|
||||
| Day | Returns a number representing the day of the month (between 1 and 31, inclusive).
🗑
|
||||
| Hour | Returns a number representing the hour of the day (between 0 and 23, inclusive).
🗑
|
||||
| Minute | Returns a number of the minutes in current system time (between 0 and 59, inclusive).
🗑
|
||||
| Month | Returns a number representing 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 the current seconds value of the current system time (between 0 and 59, inclusive).
🗑
|
||||
| Time | Returns the current system time.
🗑
|
||||
| TimeSerial | Returns the time for a specific hour, minute, and second.
🗑
|
||||
| TimeValue | Returns the current system time.
🗑
|
||||
| Weekday | Returns a number representing 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 representing the year.
🗑
|
||||
| Abs | Returns the absolute value of a number.
🗑
|
||||
| Atn | Returns the arctangent of a number.
🗑
|
||||
| Cos | Returns the cosine of an angle.
🗑
|
||||
| Exp | Returns e, the base of natural logarithms, raised to a power.
🗑
|
||||
| Hex | Returns a string representing the hexadecimal value of a number.
🗑
|
||||
| Int | Returns the integer portion of a number. If number is negative, Int returns the first integer less than or equal to number.
🗑
|
||||
| Fix | Returns the integer portion of a number. If number is negative, Fix returns the first integer greater than or equal to number.
🗑
|
||||
| Log | Returns the natural logarithm of a number.
🗑
|
||||
| Oct | Returns a string representing the octal value of a number.
🗑
|
||||
| Rnd | Returns a random number less than 1 but greater or equal to 0.
🗑
|
||||
| Round | Returns a number rounded to a specified number of decimal places.
🗑
|
||||
| Sgn | Returns an integer indicating the sign of a number.
🗑
|
||||
| Sin | Returns the sine of an angle.
🗑
|
||||
| Sqr | Returns the square root of a number.
🗑
|
||||
| Tan | Returns the tangent of an angle.
🗑
|
||||
| Chr | Returns the character specified by the ANSI character code.
🗑
|
||||
| Array | Returns an array containing the specified values.
🗑
|
||||
| Asc | Returns the ANSI character code of a string.
🗑
|
||||
| LBound | Returns the lower limit for the elements in an array.
🗑
|
||||
| UBound | Returns the upper limit for the number of elements in an array.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
SeymourSolo
Popular Computers sets