Checking CLEM expressions

Click Check in the Expression Builder (lower right corner) to validate the expression. Expressions that have not been checked are displayed in red. If errors are found, a message indicating the cause is displayed.

The following items are checked:

  • Correct quoting of values and field names
  • Correct usage of parameters and global variables
  • Valid usage of operators
  • Existence of referenced fields
  • Existence and definition of referenced globals

If you encounter errors in syntax, try creating the expression using the lists and operator buttons rather than typing the expression manually. This method automatically adds the proper quotes for fields and values.

Note: Field names that contain separators must be surrounded by single quotes. To automatically add quotes, you can create expressions using the lists and operator buttons rather than typing expressions manually. The following characters in field names may cause errors: • ! "# $% & '() = ~ |-^ ¥ @" "+ *" "<>? . ,/ :; → (arrow mark), □ △ (graphic mark, etc.)