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. |