Operators
Math operators are used in different sections of a Quiz pad. The following table explains these uses.
W – the where section of the big five. find … where … print … sort … chart
E – expressions. Both dictionary and in-line expressions.
P – print section of the big five.
Synonyms
Examples
Reserved word | Description | ![]() |
+ | ![]() Math addition operator. The “100” is a literal value. The 50 is a dictionary item with a name and value of 50. |
E |
+![]() |
![]() Plus is also used to print a field in the same column as a previous field with an indent or offset. Above prints field3 at the same starting position as field1 with an offset or indent of 5 characters. |
P |
–![]() |
![]() Math subtraction operator. |
E |
*![]() ![]() |
![]() ![]() Math multiplication operator. The “150” is a literal value. The 100 is a dictionary item with a name and value of 100. If the literal value is not a dictionary item, the number must be enclosed with quotation marks. |
E |
/![]() |
![]() Math division operator. |
E |
^![]() |
![]() Math raised to power operator. |
E |
<![]() ![]() |
![]() Math less than operator. |
W E |
>![]() ![]() |
![]() Math greater than operator. |
W E |
<=![]() ![]() ![]() ![]() |
![]() ![]() ![]() ![]() Math less than or equal operator. Above three date1 examples are identical. |
W E |
>=![]() ![]() ![]() |
![]() ![]() Math greater than or equal operator. |
W E |
<>![]() ![]() ![]() |
![]() ![]() Math not equal to operator. |
W E |
=![]() ![]() ![]() |
![]() ![]() Math equal operator |
W E |
#?![]() |
![]() field1 does not match following text anywhere in the field. Match is not case sensitive. |
W E |
=?![]() ![]() |
![]() field1 matches following text anywhere in the field. Match is not case sensitive. |
W E |
#|![]() |
![]() field1 does not begin with following text. Match is not case sensitive. |
W E |
=|![]() ![]() |
![]() field1 begins with following text. Match is not case sensitive. |
W E |
|#![]() |
![]() field1 does not end with following text. Match is not case sensitive. |
W E |
|=![]() ![]() |
![]() field1 ends with following text. Match is not case sensitive. |
W E |
|#|![]() |
![]() ![]() field1 is not equal to any of the following values. The values can be alpha or numeric characters. The values are separated by the vertical bar character “|”. Matches are not case sensitive. |
W E |
|=|![]() ![]() |
![]() ![]() field1 is equal to one of the following values. The values can be alpha or numeric characters. The values are separated by the vertical bar character “|”. Matches are not case sensitive. |
W E |
( and ) | ![]() Used to nest selections with or criteria. In above field1 must equal “abc” and field2 can be “def” or “g”. Without the parenthesis the result would include records where field1= “abc” and field2= “def” and all records where field2= “g” |
W E |
[ and ] | ![]() Square brackets used to enclose in-line expression. (See: Quiz — Expressions). |
P |
{ and } | ![]() Squiggly brackets used to enclose fields combined to print in a single column. (See: Print – Combining Fields) |
P |
Page 1 — Quiz words
Page 2 — Operators
Page 3 — Where words
Page 4 — Print words
Page 5 — Sort words
Page 6 — Chart words
Page 7 — Expression words
Page 8 — System words
Page 9 — Global words
Next – where words >