Common set of VBScript functions

vbscript| function 1. Function Array () 　
Function: Create an array variable
Format: Array (list)
Parameters: List of each numeric column in an array variable, separated by a comma
Example:
<% i = Array ("1", "2", "3")%>
Result: I was given an array

2. Function CInt () 　
Function: Converts an expression/other type of variable to an integer type (int)
Format: Cint (expression)
Parameter: expression is any valid expression/other type of variable
Example:
<%
F = "234"
Response.Write CINT (f) + 2
%>
Results: 236
function CInt () converts the character "234" to an integer 234. If the expression is empty or invalid, the return value is 0;

3. Function: Creatobject ()
Function: Creates and returns an ActiveX object.
Format: Creatobject (obname)
Parameter bname is the name of the object
Example:
<%
Set con = Server.CreateObject ("ADODB.") Connection ")
%>
Results:

4. Function CStr ()
Function: Converts an expression/other type of variable to a character type (string)
Format: Cstr (expression)
Parameter: expression is any valid expression/other type of variable
Example:
<%
s = 3 + 2
Response.Write "The result is:" & CStr (s)
%>
Result: the function CStr () converts the integer 5 to the character "5".

5. Function date () 　
Function: Returns the date of the current system (server side)
Format: Date ()
Parameters: None
Example <% date ()%>
Result: 05/10/00
　
6. Function DateAdd () 　
Function: Calculates a specified time and
Format: DateAdd (timeinterval,number,date)
Parameters: TimeInterval is the time unit (month, day ...); Number is the time interval value, date is the point of origin.
Example:
<%
currentdate = #8/4/99#
Newdate = DateAdd ("M", 3,currentdate)
Response.Write Newdate
%> <%
currentdate = #12:34:45 pm#
Newdate = DATEADD ("h", 3,currentdate)
Response.Write Newdate
%>
Results:
11/4/99
3:34:45 PM
which
"M" = "month";
"D" = "Day";
If the format is currentdate, the
"H" = "Hour";
"S" = "second";

7. Function DateDiff ()
Function: Calculates a specified time difference for a quantity
Format: DateDiff (Timeinterval,date1,date2[,firstdayofweek[,firstdayofyear]])
Parameters: TimeInterval is a time unit; Date1,date2 is a valid date expression, Firstdayofweek,firstdayofyear is any option.
Example:
<%
FromDate = #8/4/99#
ToDate = #1/1/2000#
Response.Write "There are" & _
DateDiff ("D", Fromdate,todate) & _
"Millenium from 8/4/99."
%>
Results: There are to millenium from 8/4/99.
　
8. Function Day ()
Function: Returns an integer value that corresponds to a day of the month
Format: Day (date)
Parameter: date is a valid datetime expression;
Example <% =date (#8/4/99#)%>
Results: 4

9. Function FormatCurrency ()
Functions: Converting to currency format
Format: formatcurrency (expression [, digit[,leadingdigit[,paren[,groupdigit]]]
Parameter: expression is a valid numeric expression; digit represents the number of digits after the decimal point; Leadingdigit,paren,groupdigit is any option.
Example <%=formatcurrency (34.3456)%>
Result 34.35

10. Function FormatDateTime () 　
Features: Formatting date expressions/variables
Format: FormatDateTime (Date[,nameformat])
Parameter: Date is a valid day expression/variable; NameFormat is the specified date format constant name.
Example <% =formatdatetime ("08/04/99", vbLongDate)%>
Results: Wednesday,august 04,1999
Description
--------------------------------------------------------------------------------
Describe
Returns an expression that has been formatted as a date or time.
Grammar
FormatDateTime (date[, NamedFormat])
The syntax for the FormatDateTime function has the following parameters:

Parameter description
Date required option. The date expression to be formatted.
NamedFormat can be selected. Indicates the value of the date/time format used, and if omitted, uses Vbgeneraldate.


Set up
The NamedFormat parameter can have the following values:
Constant numerical description
Vbgeneraldate 0 Displays the date and/or time. If there is a date part, the section is displayed as a short date format. If there is a time section, the section is displayed in a long time format. If all exist, all parts are displayed.
vbLongDate 1 Displays a date using the long date format specified in the computer locale.
Vbshortdate 2 displays a date using the short date format specified in the computer locale.
Vblongtime 3 Displays the time using the time format specified in the computer locale.
vbShortTime 4 Displays the time using a 24-hour format (hh:mm).

Description
The following example uses the FormatDateTime function to format an expression as a long date and assigns it to Mydatetime:
Function getcurrentdate
The FormatDateTime formats the date type as a long date type.
Getcurrentdate = FormatDateTime (Date, 1)
End Function
--------------------------------------------------------------------------------
11. Function IsNumeric () 　
Function: Returns a Boolean value that determines whether a variable is a numeric variable or another variable that can be converted to a number.
Format: isnumeric (expression)
Parameter: expression is any variable.
Example:
<%
i= "234"
Response.Write IsNumeric (i)
%>
Result: true.
　
12. Function IsObject () 　
Function: Returns a Boolean value that determines whether a variable is an object,
Format: isobject (expression)
Parameter: expression is any variable.
Example:
<%
Set con =server.creatobject ("adodb.connection")
Response.Write IsObject (Con)
%>
Result: True
　
13. Function: Lbound () 　
Function: Returns the lower bound of an array.
Format: Lbound (Arrayname[,dimension])
Parameter: Arrayname is an array variable, dimension is any item
Example:
<%
i = Array ("1", "2", "3")
Response.Write LBound (i)
%>
Results: 0

14. Function LCase () 　
Function: Converts the character of a character type variable to all lowercase characters.
Format: Lcase (String)
Parameters: string is a literal variable
Example:
<%
Str= "This is lcase!"
Response.Write Lcase (str)
%>
Result: This is lcase!

15. Function Left () 　
Function: Intercepts the front part of a string;
Format: Left (string,length)
Parameters: string strings, length intercept lengths.
Example: <% =left ("This is a test!", 6)%>
Result: this I

16. Function len () 　
Function: Returns the length of the string or the byte length of the variable
Format: Len (string *varname)
Parameters: string strings; varname arbitrary variable names
Example:
<%
Strtest= "This is a test!"
Response.Write Left (strtest)
%>
Results: 15
　
17. Function LTrim () 　
Function: Remove the space before the string.
Format: LTrim (String)
Parameters: String Strings.
Example: <% =ltrim ("This is a test!")
Result: This is a test!

18. Function Mid () 　
Function: Intercepts a string from a string.
Format: Mid (String,start [, length])
Parameters: String string, the beginning of the start intercept, length to intercept.
Example:
<%
Strtest= "This are a test, today is monday!"
Response.Write Mid (strtest,17,5)
%>
Result: Today

19. Function minute () 　
Function: Returns a value that represents the minute
Format: Minute (time)
Parameters: Time is a variable
Example lt;% =minute (#12:23:34#)%>
Results: 23

20. Function month () 　
Function: Returns a value indicating the month
Format: Month (time)
Parameters: Time is a date variable
Example <% =month (#08/09/99)%>
Results: 9

21. Function MonthName ()　
Function: Returns the string (name) of the month.
Format: MonthName (date [, ABB])
Parameter: Date is the abb=true of the month,
Example:
<% =monthname (#4/5/99#)%>
Result: April

22. Function Now () 　
Function: Returns the current time and date of the system.
Format: Now ()
Parameters: None
Example:
<% =now ()%>
Results: 05/10/00 8:45:32 pm

23. Function: replace () 　
Function: Finds in a string, substituting the specified string.
Format: replace (Strtobesearched,strsearchfor,strreplacewith [, Start[,count[,compare]]])
Parameter: strtobesearched is a string; strSearchFor is the substring being looked for; strReplaceWith is the substring to be substituted. Start,count,compare is any option.
Example:
<%
Strtest= "This is an apple."
Response.Write Replace (strtest, "Apple", "orange")
%>
Result: This is an orange.

24. Function Right () 　
Function: Intercepts the back part of a string
Format: Right (string,length)
Parameters: string strings, length intercept lengths.
Example:
<%
Strtest= "This is a test!"
Response.Write Right (strtest,3)
%>
Result: st!

25. Function rnd () 　
Function: Returns a random value
Format: rnd[(number)]
Parameter: number is any value.
Example:
<%
Randomize ()
Response.Write Rnd ()
%>
Results: One of the 0/1 values, no randomize (), can not produce random numbers.

26. Function round () 　
Function: Full value
Format: Round (Expression[,numright])
Parameters: expression numeric expression; numright any option.
Example:
<%
i=12.33654
Response.Write Round (i)
%>
Results: 12

27. Function RTrim () 　
Function: Remove the space after the string.
Format: RTrim (String)
Parameters: string is a literal
Example:
<%
Response.Write RTrim ("This is a test!")
%>
Result: This is a test!
　
28. Function second () 　
Function: Returns an integer value.
Format: Second (time)
Parameter: Time is a valid temporal expression;
Example lt;% =second (# 12:28:30#)%>
Results: 30
　
29. Function StrReverse () 　
Function: Returns a string that is in reverse order from the original string.
Format: StrReverse (String)
Parameters: string is a literal
Example <% =strreverse ("This is a test!")
Result:!tset a Si siht
　
30. Function Time () 　
Function: Returns the time value of the current system.
Format: Time ()
Parameters: None
Result: 9:58:28 Am
　
31. Function Trim () 　
Function: Delete the string before, after the space.
Format: Trim (String)
Parameters: String Strings.
Example:
<%
Strtest= ' This is a test! ”
Response.Write Trim (strtest)
%>
Result: This is a test!
　
32. Function UBound ()
Function: Returns an upper bound of an array.
Format: Ubound (expression [, dimension])
Parameters: expression is an array expression/array variable, dimension is any item
Example:
<%
i = Array ("1", "2", "3")
Response.Write UBound (i)
%>
Results: 2

33. Function: UCase ()
Function: Converts the character of a character type variable to uppercase characters.
Format: Ucase (String)
Parameters: string is a literal variable
Example:
<%
Str= "This is lcase!"
Response.Write Lcase (str)
%>
Result: This is lcase!

34. Function VarType () 　
Function: Returns the constant code of a variable (integer)
Format: Vartype (varname)
Parameter: varname is a variable name of any type.
Example:
<%
I=5
Response.Write VarType (i)
%>
Results: 2 (2 for integers, need to refer to ASP constant code.)

35. Function Weekday () 　
Function: Returns an integer that corresponds to the day ordinal of a week.
Format: Weekday (date [, Firstofweek])
Parameter: Date is a day variable and Firstofweek is an optional option.
Example:
<%
d= # 5/9/00 #
Response.Write Weekday (d)%>
Results: 3 (3 indicates Tuesday)

36. Function WeekdayName ()
Function: Returns a string that corresponds to the day of the week.
Format: WeekdayName (Weekday[,abb[,firstdayofweek]])
Parameters: Weekday is a date variable and abb,firstdayofweek is an optional option.
Example:
<%
D = #8/4/99#
Response.Write WeekdayName (d)
%>
Result: Wednesday

37. Function year () 　
Function: Returns the year in which the date expression is located.
Format: Year (date)
Parameter: Date is a valid day expression
Example:
<% =year (#8/9/99#)%>
Results: 1999
38. Function mod () function: Take remainder.
Example: 3 Mod 2
Results: 1