Tests if a character string contains only letters and digits.
$isalphanumeric(string)| string | a character string or an expression that evaluates to a character string |
1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).
This function tests if a particular character string is alphanumeric.
$isalphanumeric("abc1")Evaluates to $True.
$isalphanumeric("abc ")Evaluates to $False.
Left-justifies a character string.
$leftjustify(string)| string | a character string or an expression that evaluates to a character string |
Character string.
String is left-justified in a space that is $length(string) characters long. Leading spaces in string are ignored.
$leftjustify(" abcde")Evaluates to “abcde “.
$leftjustify(var1)
Evaluates to “3 ” if var1 is a LONGINT variable whose value is 3 (occupies 12 character spaces when converted to a string).
Returns the absolute value of a number.
$absolute(number)where
| number | a number, or an expression that evaluates to a number |
Number, positive, with the same number of decimal places as number.
Use $absolute to ensure that a number is positive (for functions such as $sqrt, for example). $absolute returns the absolute (unsigned) value of a number. The absolute value is always treated as positive.
Certain functions – for example, $sqrt – accept only positive arguments. You can use $absolute to ensure that all arguments to these functions are positive.
$sqrt($absolute(-0.98))
evaluates as if it were:
$sqrt(0.98)
Converts alphabetic characters to lower case.
$tolower(source)| source | any value, or an expression that yields any value |
Character string.
Returns a character string in which all letters are lower case. If source is not of a character data type, it is converted to a character data type before the function is applied.
$tolower("the QUICK BROWN fox is 30 years oLD")Evaluates to “the quick brown fox is 30 years old”.
output "Do you want output to go to the printer? (y/n)"
input <1>
if $tolower("#<1>") = "y" % makes user response case insensitive
set output printer
endifEnsures that the user response is case-insensitive.
Determines the month name associated with a specified date value.
$monthname(date)| date | a data, or an expression that evaluates to a date, in the form YYYYMMDD |
Character string.
This function extracts month information from standard date values. Date is often the system variable $Date.
The values returned by the $monthname function can be changed with the Language Customizer utility, ZIMLANG.
$monthname(19981225)
Evaluates to “December”.
$monthname($date+7)
Evaluates to “January” when $Date is 19981225.
Tests if a character string is a valid date.
$isdate(string)| string | a character string or an expression that evaluates to a character string |
1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).
This function tests if a particular character string is a valid date.
$isdate("19980606")Evaluates to $True.
$isdate("19980229")Evaluates to $False.
$isdate($date)
Evaluates to $True.
$isdate($date+30)
Evaluates to $True.
Calculates the sine of a number.
$sin(number)| number | a number, or an expression that evaluates to a number |
Number, with the same number of decimal places as number.
The value returned by this function has the same number of decimal places as number. Ensure that you specify enough decimal places in your equation to ensure a sufficiently granular result. Unusual results such as
-0 are an indication that the number of decimal places needs to be increased. For example, if you enter
$sin(4)
without any decimal points, you receive the result
-1
However, if you enter
$sin(4.0000)
you receive the result
-0.7568
let var1 = $sin(0)
Evaluates to 0.
Right-justifies a character string.
$rightjustify(string)| string | a character string, or an expression that evaluates to a character string |
Character string, consisting of string right-justified in a space $length(string) characters long. Trailing blanks in string are ignored.
$rightjustify("abcde ")Evaluates to ” abcde”.
$rightjustify(var1)
Evaluates to ” 3″ if var1 is a LONGINT variable whose value is 3 (occupies 12 character spaces).
Sums a set of values, excluding those in which the expression is $Null.
$total(expression)| expression | any expression |
Number.
Expression is often a WHERE expression that includes only selected values in the totalling operation. If the WHERE expression (expr1 WHERE expr2) is true, the expr1 value is included in the operation; otherwise, expression is considered $Null and is not included.
compute Employees where DeptName="Sales" evaluate(let TotSal = $total(Salary)) (let TotSalF = $total(Salary where Sex = "F"))
Finds the total of all employees’ salaries, and the total of the salaries of all female employees, in the Sales department.
Calculates the hyperbolic cosine of a number.
$cosh(number)| number | a number, or an expression that evaluates to a number, representing an angle (in radians) |
Number, with the same number of decimal places as number. Ensure that you specify enough decimal places in your equation to ensure a sufficiently granular result. Unusual results such as -0 are an indication that the number of decimal places needs to be increased. For example, if you enter
$cosh(5)
without any decimal points, you receive the result
74
However, if you enter
$cosh(5.0000)
you receive the result
74.2099
This function calculates the hyperbolic cosine of a number.
let vAngle = $cosh(3.000)
Variable vAngle is set to 10.068.
Portuguese 
English