The program supports the following types of data checks:

• Compare the field value with a constant, another field or expression
• Compare the field value with a SQL statement execution result. The program uses the first value of the first column.
• Are there values matching a regular expression
• Does the value NULL
• Does the value empty
• Does the value within the range of values
• Does the value contain substring
• Does the value in the specified list. Use ',' as value separator. Non-significant spaces are not allowed.
• Does the value in the result set of SQL statement execution. The scubber uses the first result set only.

Also there is "unconditional" check. It means the cleaning action will be executer for any data item.