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:
  1. Select from the Condition list:
    OptionDescription
    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.
  2. Click in the Value column and enter the condition text.
  3. 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.