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	Use
+	field1 + “100” + field2 + 50 Math addition operator. The “100” is a literal value. The 50 is a dictionary item with a name and value of 50.	E
+    plus	print field1 field2 field3 at field1 + “5”     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
–    minus	field1 – field2 – “100” Math subtraction operator.	E
*    multiplied_by    times	field1 * “150” < as literal    field1 * 100 < where 100 is a dictionary literal 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
/    divided_by	field1 / field2 Math division operator.	E
^    raised_to	field1 * 10 ^ decm Math raised to power operator.	E
<    less    less_than	field1 <  “100” Math less than operator.	W E
>    greater   greater_than	field1 > “100” Math greater than operator.	W E
<=    le    less_or_equal    thru    to	field1 <= “100”    date1 >= “01-01-12” and date1 <= “12-31-12”    date1 >= “01-01-12” <=  “12-31-12”    date1 from “01-01-12” to “12-31-12” Math less than or equal operator. Above three date1 examples are identical.	W E
>=    from    ge    greater_equal	field1 >= “100”    date1 from “01-01-12” to “12-31-12” Math greater than or equal operator.	W E
<>    #    not_equal    not_equal to	field1 <> “abc”    field1 <> field2 Math not equal to operator.	W E
=    is    equals    equal_to	field1 = “abc”    field1 = field2 Math equal operator	W E
#?    not_anywhere	field1 #? “corporation” field1 does not match following text anywhere in the field. Match is not case sensitive.	W E
=?    containing    contains	field1 =? “corporation” field1 matches following text anywhere in the field. Match is not case sensitive.	W E
#|    not_begins_with	field1 #| “George” field1 does not begin with following text. Match is not case sensitive.	W E
=|    begins_with    begins	field1 =| “George” field1 begins with following text. Match is not case sensitive.	W E
|#    not_ends_with	field1 |# “Smith” field1 does not end with following text. Match is not case sensitive.	W E
|=    ends_with    ends	field1 |= “Smith” field1 ends with following text. Match is not case sensitive.	W E
|#|    not_contained	field1 |#| “1|3|5|100|50”    field1 |#| “abc|def|g|MON|50” 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
|=|    ||    contained_in	field1 |=| “1|3|5|100|50”    field1 |=| “abc|def|g|MON|50” 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 )	field1= “abc” and (field2= “def” or field2= “g”) 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 ]	[ field1 where field2= “abc” else “” ] Square brackets used to enclose in-line expression. (See: Quiz — Expressions).	P
{ and }	{ city using “, “ state ”  “ zip } 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 >