Applying conditions to actions
Transforming actions can be used to change the source data before it is added to field values. You can use conditions to apply one or more actions to a field, such as add a text prefix under specific circumstances.
Procedure
For each condition you want to apply to the field:
Select from the Condition list:
Option
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 exact portion of text.
Does not end with
When the field does not end with the entered value text.
Does not start with
When the field does not start with the entered value text.
Ends with
Where the field ends with the entered value text.
Is blank
Where the field does not contain any text.
Is not blank
Where the field contains text.
Length equal to
When the field width is equal to a specific number of characters.
Length greater than
When the field width is greater than a specific number of characters.
Length less than
When the field width is less than a specific number of characters.
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 entered value text.
Click in the Value column and enter the condition text.
If required turn on Stop processing subsequent actions when conditions are met. If selected, the processing of a particular action is stopped when the condition is met. The import wizard will then continue by processing the other actions in the Actions Applied list.