Reference Guide to AXIS Script Functions
in AXIS Users Guide - AXIS Script

The following table contains an alphabetical list of all supported functions in AXIS Script language. Please follow the underlined link to get more details on a specific function.

For help on built-in functions specific to each formula table or batch please refer to the details provided in the panel directly below the function list window. To display the details check the "Details" checkbox at the top of functions list window.

Function Name Description
Abs Returns the absolute value of a number.
Asc Returns a numeric value that is the ASCII code for the first character in a string.
Atn Returns the arc tangent of a number.
CBool Converts expressions from one data type to a Boolean.
CDate Converts any valid expression to a Date variable with a vartype of 7.
CDbl Converts expressions from one data type to a double.
Choose Returns a value from a list of arguments.
Chr Returns a one-character string whose ASCII number is the argument.
CInt Converts any valid expression to an integer.
Clng Converts any valid expression to an long.
Cos Returns the cosine of an angle.
CreateObject Creates an OLE automation object.
CSng Converts any valid expression to a single.
CStr Converts any valid expression to a string.
CurDir Returns the current path for the specified drive.
CVar Converts any valid expression to a variant.
CVDate Converts any valid expression to a Date variable with a vartype of 7.
Date Returns the current system date.
DateSerial Returns a variant (Date) corresponding to the year, month and day that were passed in.
DateValue Returns a variant (Date) corresponding to the string date expression that was passed in.
Day Returns a variant date corresponding to the string date expression that was passed in.
Dir Returns a file/directory name that matches the given path and attributes.
EOF Returns a value during file input that indicates whether the end of a file has been reached.
Exp Returns the base of the natural log raised to a power (e ^ num).
FileCopy Copies a file from source to destination.
FileLen Returns a Long integer that is the length of the file in bytes.
Fix Returns the integer portion of a number.
Format Formats a string, number or variant datatype to a format expression.
FreeFile Returns an integer that is the next available file handle to be used by the Open Statement.
GetObject The GetObject Function has two parameters a filename and a class. The filename is the name of the file containing the object to retrieve. If filename is an empty string then class is required. Class is a string containing the class of the object to retrieve.
Hex Returns the hexadecimal value of a decimal parameter.
Hour The Hour Function returns an integer between 0 and 23 that is the hour of the day indicated in the parameter number.
Input Input returns characters from a sequential file.
InStr Returns the character position of the first occurrence of string2 within string1.
Int Returns the integer portion of a number.
IsArray Returns a Boolean value True or False indicating whether the parameter variablename is an array.
IsDate Returns a value that indicates if a variant parameter can be converted to a date.
IsEmpty Returns a value that indicates if a variant parameter has been initialized.
IsNull Returns a value that indicates if a variant contains the NULL value.
IsNumeric Returns a TRUE or FALSE indicating if the v parameter can be converted to a numeric data type.
IsObject Returns a Boolean value True or False indicating whether the parameter objectname is an object.
LBound Returns the smallest available subscript for the dimension of the indicated array.
LCase Returns a string in which all letters of the string parameter have been converted to upper case.
Left Returns the left most num characters of a string parameter.
Len Returns the number of characters in a string.
Log Returns the natural log of a number.
Mid Returns a substring within a string.
Minute Returns an integer between 0 and 59 representing the minute of the hour.
Month Returns an integer between 1 and 12, inclusive, that represents the month of the year.
MsgBox Displays a message in a dialog box and waits for the user to choose a button.
Now Returns a date that represents the current date and time according to the setting of the computer’s system date and time.
Oct Returns the octal value of the decimal parameter.
Right Returns the right most n characters of the string parameter.
Rnd Returns a random number.
Second Returns an integer that is the second portion of the minute in the time parameter.
Seek Seek returns a number that represents the byte position where the next operation is to take place. The first byte in the file is at position 1.
SendKeys Sends one or more keystrokes to the active window as if they had been entered at the keyboard.
Shell Runs an executable program.
Sin Returns the sine of an angle that is expressed in radians.
Space Skips a specified number of spaces in a print# statement.
Sqr Returns the square root of a number.
Str Returns the value of a numeric expression.
StrComp Returns a variant that is the result of the comparison of two strings.
String String is used to create a string that consists of one character repeated over and over.
Tan Returns the tangent of an angle as a double.
Time Returns the current system time.
TimeSerial Returns the time serial for the supplied parameters hour, minute, second.
TimeValue Returns a double precision serial number based of the supplied string parameter.
Trim, LTrim, RTrim LTrim, RTrim and Trim all Return a copy of a string with leading, trailing or both leading and trailing spaces removed.
UBound Returns the value of the largest usable subscript for the specified dimension of an array.
UCase Returns a copy of String is which all lowercase characters have been converted to uppercase.
Val Returns the numeric value of a string of characters.
VarType Returns a value that indicates how the parameter varname is stored internally.
WeekDay Returns a integer containing the whole number for the weekday it is representing.
Year Returns an integer representing a year between 1980 and 1999, inclusive. The returned integer represents the year of the serial parameter.