Today, the editor will share with you the name of the function and what the function functions are. Interested friends, let’s learn about it with the editor!
Function Name Function Function
Cbool(string) converts to boolean
Cbyte(string) Convert to a value of byte type
Ccur(string) Convert to currency value
Cdate(string) Convert to a value of the day-old type
Cdbl(string) converts to double precision value
Cint(string) Convert to integer value
Clng(string) converts to long integer value
Csng(string) converts to single-precision value
Cstr(var) converts to string value
Str(var) value converted to string
Val(string) string to numeric value
*******************
*******************
Abs(nmb) returns the absolute value of the number
Atn(nmb) Returns the arc tangent of a number
Cos(nmb) Returns the Yuxuan value of an angle
Exp(nmb) Returns the power value of the natural index
Int(nmb) Returns the shaping (carry) part of the number
Fix(nmb) Returns the skeleton (discarded) part of the number
Formatpercent(expression) Returns percentage
Hex(nmb) Returns the hex number of data
Log(nmb) Returns natural logarithm
Oct(nmb) Returns the angular number of the number
Rnd returns a random number greater than "0" and less than "1"
Sgn(nmb) determines the positive and negative signs of a number
Sin(nmb) Returns the Zhenghyun value of the angle
Sqr(nmb) returns the quadratic root of the number
Tan(nmb) Returns the tangent value of a number
Asc(string) Returns ASCII string
Chr(charcode) Return characters according to character code
Instr(string,searchstr) Returns the first character position of the searched string, string is a string, and searchstr is a string to be searched
InstrRev(string,searchstr) Same as above, just start searching from the right
Lcase(var) Change the string to lowercase
Left(string,nmb) Returns nmb strings starting from the left from string
Len(string) Returns the length of the string
Ltrim(string) Cut off the space on the left side of the string
Filter(inputstrings,value) Returns the character set of string arrays. Inputstrings is a string group and value is the character searched for in the array.
Rtrim(string) Cut off the space on the right side of the string
Trim(string) Cut off the spaces before and after the string
Mid(string,start,len) Returns len characters starting from the start position in string
Replace(string,find,withstr) In string string, use withstr to replace find string
Right(string,nmb) Returns nmb strings starting from the right from string
Space(nmb) Returns the string with the specified space
StrComp(string1,string2) Compare two strings
Ucase(string) Turn string into uppercase
*******************
*******************
Date() Returns the current system date
DateAdd(interval,nmb,date) returns a date with the specified time interval with an additional time interval. interval is the interval type, yyyy-year, m-month, d-day, h-hour, n-minute.
DateDiff(interval,nmb1,nmb2) returns two time intervals, the meaning of interval is the same as above
Datevalue(date) Play the date part in Date
Day(date) Returns the number of days
FormatDatetime(date) Returns an expression formatted as a date
Hour(time) Returns the number of hours of time
Minute(time) Returns the number of minutes of time
Month(date) Returns the month in the date
Now() returns the date and time of the system
Second(time) Returns the number of seconds in time
Time() Returns the current time of the system
Weekday(date) Return to the day of the week
WeekdayName(date) Returns the Chinese name of the day of the week
Year(date) Return to year
IsArray(var) determines whether a variable is an array
IsDate(var) determines whether a variable is a date
IsNull(var) determines whether a variable is empty
IsNumeric determines whether the expression contains numeric values
IsObject(var) determines whether a variable is an object
TypeName(var) Returns the data type of the variable
*******************
*******************
Array(list) Returns an array
CreateObject(class) Create an object
GetObject(pathfilename) Get file object
Inputbox(prompt) provides a dialog box for inputting data
LBound(arrayP Returns the minimum index of the array
Msgbox(string) outputs a message box
Split(liststr) Returns a one-dimensional array from a list string
Ubound(array) Returns the maximum index of the array
The above is an introduction to the full content of the function name and function function. I hope the relevant knowledge and materials compiled by the editor will be helpful to you. For more content, please continue to pay attention to the website of the Wuxin Technology Channel!