The following list all functions that have been included as new features and those that have been enhanced.
The NewLine function accepts a NewLine Count value, this specifies the number of new line characters to be inserted.
Returns a character to represent a new line character within a text string. Multiple new line characters can also be returned.
NEWLINE([NewLine Count])
NewLine Count (optional) is the number of newline characters to insert.
If the NewLine Count value exceeds the maximum the function will revert to 10000.
| Rule | Meaning |
|---|---|
| "Hello" & NEWLINE( ) & "World" | Returns: Hello World |
| "Hello" & NEWLINE(2) & "World" | Returns: Hello
World |
Repeats the specified text n number of times.
If the Repeat Quantity value exceeds the maximum the function will revert to 10000.
REPT( [Text], [Number of Times] )
Repeats the specified text n number of times.
Text is the string to repeat.
Number of Times is the number of times to repeat the specified text by.
Rule | Meaning |
|---|---|
| REPT("F", 6) | This function repeats the string "F" six times, which will return "FFFFFF" as the result. |
| REPT("F", 10001) | This function repeats the string "F" 10000 times, the repeat quantity limit is 10000 |
Text | Number of Times | Outcome |
|---|---|---|
| "_" | 10 | __________ (Uses the underscore symbol to create a horizontal line) |
| "Delete" | 0 | "" (the text is omitted) |
| "-TEST-" | 5 | -TEST--TEST--TEST--TEST--TEST- |
Rounds a number up to the nearest specified significance.
CEILING( [Number], [Significance] )
Number is the number to round.
Significance is the number to which this function finds the nearest (higher valued) multiple of.
Rule | Meaning |
|---|---|
| CEILING(123.456, 9) | Rounds the number 123.456 up to the nearest multiple of 9. The resulting value is 126. |
Rounds a number down to the nearest specified significance.
FLOOR( [Number], [Significance] )
Number is the number to round.
The significance is the number to which this function finds the nearest (lower valued) multiple of.
Rule | Meaning |
|---|---|
| FLOOR(123.456, 9) | Rounds the number 123.456 down to the nearest multiple of 9. The resulting value is 117. |
Returns a table sorted on the given column.
TableSort(Table or Table Name As Object, Column As Double, Has Headers As Boolean, Sort Ascending As Boolean) As Object
Where:
Table or Table Name is a Table array (such as the data in a standard table, or the result of a QueryDataValues function).
Column is the column on which to base the sort. Number starting at 1 for the first column.
Has Headers is TRUE will treat the first row as headers (therefore exclude from the sort). FALSE will sort the entire table (including the first row).
Sort Ascending is TRUE to to sort in ascending order, FALSE to sort in descending order.
| Rule | Meaning |
|---|---|
| ListAll(TableSort(DwTableName,2,FALSE), 3) | Will list all data from the third column of the array returned by the SortTable function. |
Returns the absolute value of an angle in radians.
AngleAbs(Angle)
Where:
Angle is the angle, in radians, for which you want the absolute value.
| Rule | Meaning |
|---|---|
| AngleAbs(-0.785398163397448) | Will return the absolute angle in radians, the result of which will be 5.49778714378214. |
Returns the absolute value of an angle in degrees.
AngleAbsD(Angle)
Where:
Angle is the angle, in degrees, for which you want the absolute value.
| Rule | Meaning |
|---|---|
| AngleAbsD(-45) | Will return the absolute angle in degrees, the result of which will be 315. |
See also