Common Function tables

ABS (number) gets the absolute value of the value.
ASC (string) obtains the first ASCII code of a string expression.
ATN (number) gets the arc tangent value of an angle.
Callbyname (object, procname, usecalltype, [ARGs ()]) is used to execute the method, set, or return the attributes of an object.
The cbool (expression) Conversion expression is of the boolean type.
The cbyte (expression) Conversion expression is a byte type.
The cchar (expression) Conversion expression is in the accept state.
The cdate (expression) Conversion expression is of the date type.
The cdbl (expression) Conversion expression is of the double type.
The cdec (expression) Conversion expression is of the decimal type.
The CINT (expression) Conversion expression is of the integer type.
The clng (expression) Conversion expression is of the long type.
The cobj (expression) Conversion expression is of the object type.
The cshort (expression) Conversion expression is of the short type.
The csng (expression) Conversion expression is of the single type.
The CSTR (expression) Conversion expression is of the string type.
Choose (index, choice-1 [, choice-2,... [, choice-N]) selects the index value and returns the set parameter.
CHR (charcode) obtains the character content in ASCII code.
Close (filenumberlist) ends the archive enabled with open.
Cos (number) gets the cosine of an angle.
The type of the ctype (expression, typename) Conversion expression.
Dateadd (dateinterval, number, datetime) plus or minus the date or time.
Datediff (dateinterval, date1, date2) calculates the difference between two dates or times.
Datepart (dateinterval, date) is sent back to the year, month, day, or time based on the received date or time parameter.
Dateserial (year, month, day) combines the received parameters into a data of date type only with date.
Datevalue (datetime) obtains the date value that conforms to the country-specific style and contains the time.
Day (datetime) is returned to the date based on the received date parameter.
EOF (filenumber) returns true when it reaches the end of an opened file.
Exp (number) returns the power of e Based on the received parameter.
Filedatetime (pathname) returns the date and time when the file was created.
The length of the file returned by filelen (pathname) in bytes.
Filter (sourcearray, Match [, include [, compare]) searches for the specified string in the string array. If the array element contains the specified string, it is combined into a new string array and transmitted back. If you want to return an array element that does not contain the specified string, set the include parameter to false. The compare parameter is used to set whether the search is case sensitive. In this case, you only need to give textcompare constants or 1.

Fix (number) removes the fractional part of the parameter and returns the result.
Format (expression [, style [, firstdayofweek [, firstweekofyear]) converts the date, time, and value data into a format acceptable to every country.

Formatcurrency (expression [, numdigitsafterdecimal [, includeleadingdigit]) outputs the value as the amount type.

The numdigitsafterdecimal parameter indicates the number of decimal words, And the deleadingdigit parameter indicates whether to fill in the number of integer words when the integer is 0.
Formatdatetime (date [, namedformat]) returns formatted date or time data.
Formatnumber (expression [, numdigitsafterdecimal [, includeleadingdigit ])
. The numdigitsafterdecimal parameter indicates the number of decimal words, And the deleadingdigit parameter indicates whether to fill in the number of integer words when the integer is 0.
Formatpercent (expression [, numdigitsafterdecimal [, includeleadingdigit]) returns numerical data in percent format. The numdigitsafterdecimal parameter indicates the number of decimal words, And the deleadingdigit parameter indicates whether to fill in the number of integer words when the integer is 0.

Getattr (filename) returns the attribute value of the file or directory.
Hex (number) converts a value to a hexadecimal value.
The hour field of the time returned by hour (time). The type is integer.
IIF (expression, truepart, falsepart) executes the program of the truepart field when the return value of the expression is true. Otherwise, the program executes the falsepart field.

Instr ([start,] string1, string2) searches for the characters set by the string2 parameter to appear in the character strings. Start is used to search for the characters. string1 is the string to be searched, string2 is the character to be searched.

INT (number) returns an integer smaller than or equal to the maximum integer of the received parameter.
Isarray (varname) determines whether a variable is of the array type. If it is an array, true is returned. Otherwise, false is returned.
Isdate (expression) determines whether the expression content is of the datetime type. If the expression content is of the datetime type, true is returned. Otherwise, false is returned.
Isdbnull (expression) determines whether the expression content is null. If it is null, true is returned. Otherwise, false is returned.
Isnumeric (expression) is used to determine whether the expression content is in a numeric state. If it is used, true is returned, and false is returned.
Join (sourcearray [, delimiter]) merges string arrays into unique strings. The delimiter parameter is set to add new strings to each element.
Lcase (string) converts a string to a lowercase font.
Left (string, length) gets the characters with the length parameter set length starting from the left side of the string.
Len (string) gets the length of the string.
Log (number) gets the natural logarithm of the value.
Ltrim (string) removes the left blank part of the string.
Mid (string, start [, length]) retrieves the string of the length after the character set by the Strat parameter in the string. If the length parameter is not set, all the characters after the start are retrieved.

Minute (time) gets the time content of the part, type is integer.
Mkdir (PATH) creates a new directory.
Month (date) indicates the month of the date. The type is integer.
Monthname (month) is used to obtain the complete description of the month based on the received month value.
Now () gets the current date and time.
Oct (number) converts a value to an octal value.
Replace (expression, find, replace) converts the string specified by the find parameter in the string to the string specified by the replace parameter.
Right (string, length) is a character set by the length parameter, which is obtained from the right of the string.
Rmdir (PATH) removes an empty directory.
RND () is used to obtain decimal places between 0 and 1. If different values are to be obtained each time, randomize must be added before use.
Rtrim (string) removes the white space on the right of the string.
The second part of the time content obtained by second (time). The type is integer.
Sign (number) indicates whether the value is positive or negative. If the value is positive, 1 is returned. If the value is negative,-1 is returned. If the value is 0, 0 is returned.
Sin (number) returns the sine of an angle.
Space (number) gets the blank string set by the number parameter.
Split (expression [, delimiter]) Splits a string into a String Array Based on the condition string set by the delimiter parameter.
SQRT (number) returns the square root of a number.
STR (number) converts a number into a string and returns it.
Strreverse (expression) returns the result after the string content is reversed.
Tan (number) returns the tangent of an angle.
Timeofday () gets the time that does not contain the date currently.
Timer () gets the number of seconds from 0: 00 to the current time. The type is double.
Timeserial (hour, minute, second) combines the received parameters into a data with only the time date type.
Timavalue (time) gets the time value that matches the country-specific style.
Today () gets the date that today does not contain the time.
Trim (string) removes the white space at the beginning and end of the string.
Typename (varname) gets the type of the variable or object.
Ubound (arrayname [, dimension]) obtains the final index value of the array. The dimension parameter is used to obtain the final index value of the dimension.
Ucase (string) converts a string to uppercase.
Val (string) converts a numeric string to a numeric State. If the string contains non-numeric content, it is removed and merged into a number.
In the weekday (date) parameter, the date is the day of the week, Sunday is 1, Monday is 2, and Tuesday is 3.
Weekdayname (number) gets the name of the week according to the received parameter. The parameters that can be received are 1 to 7, and the parameters that can be received are 1 on Sunday, 2 on Monday, and 3 on Tuesday.