Sideway
output.to from Sideway





Draft for Information Only

VBScript Functions

Predefined Function

Table of VBScript language function features

FunctionDescription 
Abs FunctionCreate an unsigned magnitude, or the absolute value of a given number.
last updated 2017/9/16
Array FunctionCreate a zero-based one-dimensional array from a given comma-delimited list of values by arranging the elements of the ordered list as members of the array.
last updated 2017/9/16
Asc FunctionCreate an ANSI character code number from the first character of a given string by encoding the first character of the given string as the associated ANSI character of the ANSI character code.
last updated 2017/9/16
AscB FunctionCreate a Byte from the first byte of the character code of first character of a given string.
last updated 2017/9/16
AscW FunctionCreate a decimal Unicode (wide) character code from the character code of first character of a given string.
last updated 2017/9/16
Atn FunctionConverts a given number to an angle in radian by taking the inverse trigonometric function of tangent function of the given number.
last updated 2017/9/16
CBool FunctionCreate a Boolean result value of a given expression.
last updated 2017/9/16
CByte FunctionCreate a Byte data subtype value from a given expression.
last updated 2017/9/16
CCur FunctionCreate a Currency data subtype value from a given expression.
last updated 2017/9/16
CDate FunctionCreate a Date data subtype value from a given expression.
last updated 2017/9/16
CDbl FunctionCreate a Double data subtype value from a given expression.
last updated 2017/9/16
Chr FunctionCreate an ANSI character string from a given charcode by evaluating the given charcode as the ANSI character code of the associated character.
last updated 2017/9/16
ChrB FunctionCreate a character string from a given charcode by evaluating the given charcode as the Byte code of the associated character.
last updated 2017/9/16
ChrW FunctionCreate a character string from a given charcode by evaluating the given charcode as the Unicode (wide) character code or Unicode/DBCS of the associated Unicode character.
last updated 2017/9/16
CInt FunctionCreate an Integer data subtype value from a given expression.
last updated 2017/9/17
CLng FunctionCreate a Long data subtype value from a given expression.
last updated 2017/9/17
Cos FunctionConverts a given number to the cosine of the given number by taking the given number as an angle in radian.
last updated 2017/9/17
CreateObject FunctionCreate a reference to an automation object specified by servername and typename arguments of the object on a location according to the location argument.
last updated 2017/9/17
CSng FunctionCreate a Single data subtype value from a given expression.
last updated 2017/9/17
CStr FunctionCreate a String data subtype value from a given expression.
last updated 2017/9/17
Date FunctionCreate a date part of the date from the current date of a local computer system with format according to the date setting of the local computer system.
last updated 2017/9/17
DateAdd FunctionCreate a date from a given date by adding the specified number of interval to the given date.
last updated 2017/9/17
DateDiff FunctionCreate a number from two given dates by counting the specified interval from date1 to date2 according to firstdayofweek and firstweekofyear setting.
last updated 2017/9/18
DatePart FunctionCreate a Integer from a given valid Date expression according the the specified interval argument, and firstdayofweek and firstweekofyear settings.
last updated 2017/9/18
DateSerial FunctionCreate a date from given numeric expressions of year, month, and day.
last updated 2017/9/18
DateValue FunctionCreate a date part of date from a given acceptable date string.
last updated 2017/9/18
Day FunctionCreate an Integer with value between 1 and 31 inclusive for representing the 31 days of a month respectively from a given date expression by getting the day part of the given date expression.
last updated 2017/9/18
Escape FunctionCreate a String from a given charString by encodeing the unallowable characters of the given charString by the correpsonding character code. While the allowable characters, i.e. *, +, -, ., 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, @, A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z, _, a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t, u, v, w, x, y, z, of the given charString remains unchanged.
last updated 2017/9/18
Eval FunctionCreate a evaluation result from a given expression.
last updated 2017/9/18
Exp FunctionConverts a given number to the base of natural logarithms, e, raised to a power of the given number.
last updated 2017/9/18
Filter FunctionCreate a zero-based array by filtering a given InputStrings according to the specified search Value, and the specified Include and Compare settings.
last updated 2017/9/18
Fix FunctionCreate an integer value of a given number that is equal to the integer part of the given number by removing the fractional part or non-integer part of the given number.
last updated 2017/9/19
FormatCurrency FunctionCreate a string of a formatted currency value expression with a currency symbol defined in the local computer's regional settings from a given numeric or is evaluated as numeric expression according to local system settings and specified arguments.
last updated 2017/9/18
FormatDateTime FunctionCreate a string of a formatted date or time value expression from a given date or is evaluated as date expression according to local system settings and specified arguments.
last updated 2017/9/18
FormatNumber FunctionCreate a string of a formatted number value expression from a given numeric or is evaluated as numeric expression according to local system settings and specified arguments.
last updated 2017/9/18
FormatPercent FunctionCreate a string of a formatted percentage value expression from a given numeric or is evaluated as numeric expression by multiplying the numeric value with 100 and adding a trailing % character according to local system settings and specified arguments.
last updated 2017/9/19
GetLocale FunctionCreate a number from the scripting engine of the local system to indicate the current locale ID value of scripting language in use.
last updated 2017/9/19
GetObject FunctionCreate a reference to an automation object from a file specified by pathname argument and/or a class of the object specified by the appname and objectype argumens of the class argument.
last updated 2017/9/19
GetRef FunctionCreate a reference to a procedure specified by procname argument.
last updated 2017/9/19
Hex FunctionCreate a hexadecimal number String from a given number by converting the decimal value of the given number from base 10 to a hexadecimal number of base 16.
last updated 2017/9/19
Hour FunctionCreate an Integer with value between 0 and 23 inclusive for representing the 24 hours of a day respectively from a given time expression by getting the hour part of the given time expression.
last updated 2017/9/19
InputBox FunctionCreate and display a standard input dialog box with a text box and a given prompt in the dialog box according to the specified title, default, xpos, ypos, helpfile and context arguments. The dialog box will wait for the user to input text or click a button to continue.
last updated 2017/9/19
InStr FunctionCreate a number from a given string1 by getting the position of the first occurrence of a specified string2 through searching from the specified searching position start towards the end of the given string1 according to the specified compare setting.
last updated 2017/9/19
InStrB FunctionCreate a number from a given string string1 by getting the first byte position of the first occurrence of a specified string string2 through searching from the specified searching position byte start towards the end of the given string string1 without consider the specified compare setting.
last updated 2017/9/19
InStrRev FunctionGet the position of the first occurrence of a specified string within another given string by searching from the specified start searching position, default is at the end of string, towards the start of the given string.
last updated 2017/9/19
Int FunctionCreate an integer value of a given number that is less than or equal to the given number.
last updated 2017/9/19
IsArray FunctionCreate a Boolean result value from a given varname indicating whether the given varname is or can be contained by a Variant of Array data subtype.
last updated 2017/9/19
IsDate FunctionCreate a Boolean result value from a given expression indicating whether the given expression is or can be contained by a Variant of Date data subtype.
last updated 2017/9/19
IsEmpty FunctionCreate a Boolean result value from a given expression indicating whether the given expression is an uninitialized individual.
last updated 2017/9/19
IsNull FunctionCreate a Boolean result value from a given expression indicating whether the given expression contains no valid data.
last updated 2017/9/19
IsNumeric FunctionCreate a Boolean result value from a given expression indicating whether the given expression can be evaluated as a numeric value.
last updated 2017/9/19
IsObject FunctionCreate a Boolean result value from a given expression indicating whether the given expression references a valid Automation object.
last updated 2017/9/19
Join FunctionCreate a string from a given one-dimensional array list of substrings by joining all elements in the array accroding to the index numebr with the specified delimiter.
last updated 2017/9/20
LBound FunctionCreate a number from a given arrayname to represent the smallest available subscript of the given arrayname according to the specified dimension.
last updated 2017/9/20
LCase FunctionCreate a string from a given string by converting all uppercase letters of the given string to lowercase letters.
last updated 2017/9/16
Left FunctionCreate a substring of specified character length from the left side of a given string.
last updated 2017/9/20
LeftB FunctionCreate a substring of specified Byte length from the left side of a given string.
last updated 2017/9/20
Len FunctionCreate a number from a given string or a specified variable by counting the number of characters in the given string or the specified variable.
last updated 2017/9/20
LenB FunctionCreate a number from a given string or a specified variable by counting the number of bytes in the given string or the specified variable.
last updated 2017/9/20
LoadPicture FunctionCreate a reference to a picture object from the a file specified by picturename argument.
last updated 2017/9/20
Log FunctionConverts a given number to the natural logarithm of the given number to base e.
last updated 2017/9/20
LTrim FunctionCreate a left trimmed string from a given string expression by removing all leading spaces on the left side of a string.
last updated 2017/9/16
Mid FunctionCreate a substring of specified character length from the specified position start of a given string toward the end of the string.
last updated 2017/9/20
MidB FunctionCreate a substring of specified byte length from the specified byte position start of a given string toward the end of the string.
last updated 2017/9/20
Minute FunctionCreate an Integer with value between 0 and 59 inclusive for representing the 60 minutes of an hour respectively from a given time expression by getting the minute part of the given time expression.
last updated 2017/9/20
Month FunctionCreate an Integer with value between 1 and 12 inclusive for representing the 12 months of a year respectively from a given date expression by getting the month part of the given date expression.
last updated 2017/9/20
MonthName FunctionCreate a String from a given month expression by taking the given month expression as the numeric designation of the month between 1 and 12 inclusive, and with value representing the corresponding month of a year according to the specified abbreviate setting.
last updated 2017/9/20
MsgBox FunctionCreate and display a standard message dialog box with a given prompt in the dialog box according to the specified buttons, title, helpfile and context arguments. The dialog box will wait for the user to click a button to continue.
last updated 2017/9/20
Now FunctionCreate a date from the current date of a local computer system with format according to the date setting of the local computer system.
last updated 2017/9/20
Oct FunctionCreate a octal number String from a given number by converting the decimal value of the given number from base 10 to a octal number of base 8.
last updated 2017/9/20
Replace FunctionCreate a string from a substring specified by start of a given expression after replacing a specified find string with a given replacewith string according to the specified count and compare.
last updated 2017/9/20
RGB FunctionCreate a whole number from the given red, green, and blue argument according to the RGB color converting rule.
last updated 2017/9/21
Right FunctionCreate a substring of specified character length from the right side of a given string.
last updated 2017/9/21
RightB FunctionCreate a substring of specified Byte length from the right side of a given string.
last updated 2017/9/21
Rnd FunctionGet a random number according to a specified number setting.
last updated 2017/9/21
Round FunctionCreate a numeric value of a given numeric expression according to the number of decimal places specified by numdecimalplace using the round to nearest method and following the round half to even rule that is to return the possible numeric value closest to the value of the numeric expression with the appropriate number of decimal, and following the closest to the round halt to even rule when the numeric expression is exactly halfway between two possible rounded values.
last updated 2017/9/21
RTrim FunctionCreate a right trimmed string from a given string expression by removing all trailing spaces on the right side of a string.
last updated 2017/9/16
ScriptEngine FunctionCreate a String from the scripting engine of the local system to indicate the scripting language in use.
last updated 2017/9/21
ScriptEngineBuildVersion FunctionCreate a number from the scripting engine of the local system to indicate the build version number of scripting language in use.
last updated 2017/9/21
ScriptEngineMajorVersion FunctionCreate a number from the scripting engine of the local system to indicate the major version number of scripting language in use.
last updated 2017/9/21
ScriptEngineMinorVersion FunctionCreate a number from the scripting engine of the local system to indicate the minor version number of scripting language in use.
last updated 2017/9/21
Second FunctionCreate an Integer with value between 0 and 59 inclusive for representing the 60 seconds of a minute respectively from a given time expression by getting the second part of the given time expression.
last updated 2017/9/21
SetLocale FunctionCreate a number from the scripting engine of the local system to indicate the current locale ID value of scripting language in use. And then set the global locale ID value of scripting language according to the specified lcid for the scripting engine of the local system.
last updated 2017/9/21
Sgn FunctionCreate an integer to indicate the sign of a given number.
last updated 2017/9/21
Sin FunctionConverts a given number to the sine of the given number by taking the given number as an angle in radian.
last updated 2017/9/21
Space FunctionCreate a string of a specified number of repeating spaces.
last updated 2017/9/21
Split FunctionCreate a zero-based one-dimensional array from a given expression by breaking the string of the given expression from the beginning to the end into a list of ordered substring elements which is then arranged as members of the array.
last updated 2017/9/16
Sqr FunctionCreate the square root of a given number.
last updated 2017/9/21
StrComp FunctionCreate a value to indicate the result of comparison between given string1 and string2 according to the specified compare setting.
last updated 2017/9/21
String FunctionCreate a string of a specified number of the repeating character obtained from the first character of a given string expression specified by character argument.
last updated 2017/9/21
StrReverse FunctionCreate a string from a given string1 by reversing the character order of the given string1 from the end to the beginning.
last updated 2017/9/21
Tan FunctionConverts a given number to the tangent of the given number by taking the given number as an angle in radian.
last updated 2017/9/21
Time FunctionCreate a time part of the date from the current date of a local computer system with format according to the time setting of the local computer system.
last updated 2017/9/21
Timer FunctionCreate a numeric value from time part of current local system time by counting the elapsed seconds since 12:00 AM, midnight, or 00:00.
last updated 2017/9/21
TimeSerial FunctionCreate a date from given numeric expressions of hour, minute, and second.
last updated 2017/9/21
TimeValue FunctionCreate the time part of a date from a given date string.
last updated 2017/9/21
Trim FunctionCreate a trimmed string from a given string expression by removing both leading and trailing spaces on both sides of a string.
last updated 2017/9/16
TypeName FunctionCreate a String from a given varname to indicate the Variant subtype name of a variable.
last updated 2017/9/21
UBound FunctionCreate a number from a given arrayname to represent the largest available subscript of the given arrayname according to the specified dimension.
last updated 2017/9/21
UCase FunctionCreate a string from a given string by converting all lowercase letters of the given string to uppercase letters.
last updated 2017/9/16
Unescape FunctionDecodes a string encoded with the Escape function.
last updated 2017/9/21
VarType FunctionCreate an Integer from a given varname to indicate the subtype of a variable.
last updated 2017/9/21
Weekday FunctionCreate an Integer with value between 1 and 7 inclusive for representing the 7 days of a week respectively from a given date expression by getting the default weekday part of the given date expression according to firstdayofweek setting.
last updated 2017/9/21
WeekdayName FunctionCreate a String from a given weekday expression by taking the given weekday expression as the numeric designation of the week between 1 and 7 inclusive based on the specified firstdayofweek setting, and with value representing the corresponding weekday of a week according to the specified abbreviate setting.
last updated 2017/9/21
Year FunctionCreate a Integer from a given date expression by getting the year part of the given date expression.
last updated 2017/9/21

Sources


┬ęsideway

ID: 170900007 Last Updated: 2017/11/6 Revision: 1

IMAGE

Home (1)

Business

Management

HBR (3)

Information

Recreation

Hobbies (7)

Culture

Chinese (1097)

English (330)

Reference (60)

Computer

Hardware (148)

Software

Application (187)

Digitization (22)

Numeric (19)

Programming

Web (508)

HTML

Knowledge Base

Common Color (1)

Html Entity (Unicode) (1)

Html 401 Special (1)

OS (337)new

MS Windows

Windows10 (1)

DeskTop (5)

Knowledge

Mathematics

Formulas (7)

Number Theory (54)

Algebra (14)

Trigonometry (18)

Geometry (18)

Calculus (66)

Engineering

Tables (8)

Mechanical

Control

Process Control (1)

Mechanics (1)

Rigid Bodies

Statics & Dynamics (128)

Fluid (5)

Fluid Kinematics (5)

Acoustics (19)

FiniteElement (2)

Biology (1)

Geography (1)


Copyright © 2000-2018 Sideway . All rights reserved Disclaimersfacebook last modified on 08 Mar 2018