Skip to content

Simple Operators

Simple operators in BizzStream allow you to perform basic operations on field data, such as mathematical calculations, string concatenation, and value comparisons.

Math Operators

Math operators enable you to perform arithmetic calculations like addition, subtraction, multiplication, division, and exponentiation. These operations follow the standard mathematical order of execution.

Addition and Subtraction (+, -)

You can add or subtract field values using the + and - operators.

Examples

  • F["quantity"] + 1 → Increments the value of "quantity" by 1.
  • F["subtotal"] - F["discount"] → Subtracts the "discount" value from "subtotal".

Multiplication and Division (*, /)

You can multiply and divide values using the * and / operators.

Examples

  • F["price"] * F["quantity"] → Computes the total cost by multiplying "price" with "quantity".
  • F["total"] / 3 → Returns 5 if "total" equals 15.
  • F["total"] / F["items"] → Calculates the average value by dividing "total" by "items".

Exponentiation (^)

You can raise a number to a power using the ^ operator.

Examples

  • F["item1"] ^ F["item2"] → Returns 8 if "item1" is 2 and "item2" is 3 (2^3 = 8).
  • F["total"] ^ 3 → Returns 8 if "total" equals 2 (2^3 = 8).

String Operator (&)

The concatenation operator & allows you to merge multiple string values into one.

Examples

  • F["firstName"] & F["lastName"] → Returns "JoeSmith" if "firstName" is "Joe" and "lastName" is "Smith".
  • "My name is " & F["firstName"] & " " & F["lastName"] → Returns "My name is Joe Smith".

Comparison Operators

Comparison operators allow you to compare numbers, dates, and times. They are often used in combination with the IF operator (Boolean Operators).

Comparison Operators Table

Operator Description
= Equals
<> or != Not equal to
> Greater than
>= Greater than or equal to
< Less than
<= Less than or equal to

Examples

  • F["quantity"] = 10 → Checks if "quantity" equals 10.
  • F["status"] <> "Completed" → Checks if "status" is not "Completed".
  • F["price"] > 100 → Checks if "price" is greater than 100.
  • F["quantity"] >= F["minQuantity"] → Checks if "quantity" is at least "minQuantity".
  • F["rating"] < 4.5 → Checks if "rating" is below 4.5.
  • F["age"] <= 18 → Checks if "age" is 18 or younger.
  • TODAY() > "2024-01-01" → Checks if today's date is after January 1, 2024 .
  • "09:00" < "15:00" → Checks if 9 AM is before 3 PM.

Summary

  • Math Operators: Perform basic arithmetic calculations.
  • String Operator: Concatenates text values.
  • Comparison Operators: Evaluate conditions for numbers, dates, and times.

These operators help create dynamic expressions within BizzStream, enabling more flexible and interactive document processing.