Software Owner's manual

Section 5. Split
variable X). A comma must follow each variable statement, as with all
parameters in the Select line. Once the variables have been declared they can
be used later in the Select line (i.e., x=4-5∗(6∗3.0), y=6/3,2,3,6,7,7∗x,6+y).
Variables can be defined in the first four Input File’s Select
lines only, but may be used in subsequent Input File’s Select
lines.
NOTE
Illegal operations (e.g., logarithm of a negative number) will cause Split to
store blanks for the Output. It is possible to get a run time error (error 0/1) if
the floating point math exceeds the limits of the PC.
5.3.1.9
5
Numerical Limitations
The greatest number that can be output is determined by the field width (Output
File tab). If the width is eleven or greater, the maximum number is 99,999,999;
for widths from eight through ten the maximum is 99,999; for widths less than
eight the maximum is 9999. If a column is not large enough for a value, it will
be stored as a 9,999, 99,999 or 99,999,999 based on the column width. In some
instances, such as when a column is not large enough for the date function, you
will see the text “bad data” on the Split Runtime window.
.3.1.10 Mathematical Functions, Details, and Examples
TABLE 5-6. Split Operators and Math Functions
OPERATORS OPERATOR PRECEDENCE ORDER
(3 = high, 1 = low)
^ = raise to the power 3
x Mod y = Modulo divide of x by y 2
∗ / = multiplication, division 2
+ - = addition, subtraction 1
EXAMPLES OF SYNTAX FOR MATHEMATICAL OPERATORS
3∗5 multiply element 3 by element 5
3/5 divide element 3 by element 5
(3..5)/(8..10) same as 3/8, 4/9, 5/10
3+5 add element 3 to element 5
3-5 subtract element 5 from element 3
(3,9,5)-(8,7,10) same as 3-8, 9-7, 5-10
3∗2.0 multiply element 3 by a fixed number 2
2^3.0 raise element 2 to the third power
MATH FUNCTIONS
Abs(x) = Absolute value of x
Arctan(x) = Arc tangent of x (in degrees)
Cos(x) = Cosine of x (in degrees)
Exp(x) = Natural Exponent function (e
x
)
Frac(x) = Fractional portion of x
Int(x) = Integer portion of x
Ln(x) = Natural logarithm of x
Sin(x) = Sine of x (in degrees)
SpaAvg(x..y) = Spatial average of elements x through y
SpaMax(x..y) = Spatial maximum of elements x through y
SpaMin(x..y) = Spatial minimum of elements x through y
SpaSd(x..y) = Spatial standard deviation of elements x through y
Sqrt(x) = Square root of x
5-23