Column action conditions
In the Analyst's Notebook import wizard, you can configure column actions so that they run only when specific conditions are met. The following table contains a complete list of the available conditions.
| Condition | Description |
|---|---|
| Contains | Where the field contains the exact portion of text, which can be at the start, middle or end of the field. |
| Does not contain | Where the field does not contain the specified sequence of characters. |
| Does not end with | When the field does not end with the specified sequence of characters. |
| Does not start with | When the field does not start with the specified sequence of characters. |
| Ends with | Where the field ends with the specified sequence of characters. |
| Is blank | Where the field is blank. |
| Is not blank | Where the field is not blank. |
| Length equal to | Where the field length (in characters) is equal to the specified number. |
| Length greater than | Where the field length (in characters) is greater than the specified number. |
| Length less than | When the field length (in characters) is less than the specified number. |
| Regular expression | When the data meets a general pattern set by the specified expression. For example, the expression [0-9] will match on 1, 2, 3, 4 up to 9. |
| Starts with | When the data starts with the specified sequence of characters. |