Extract substring (Delimiter)

A cleansing rule of this type can be used to cleanse imported supplier item data to the effect that text parts that are located between two delimiters are extracted from supplier attribute values in order to allocate them to the corresponding iPIM Supply attributes. In each case, the first occurrence of the specified delimiter is taken into account. Only in the case of two identical delimiters, the first and the second occurrence of the delimiter are taken into account.

Note
This rule type can only be applied to character string attributes.

In order to set up a cleansing rule of this type, proceed as follows:

  1. From the “Choose rule type” menu, select the rule type “Extract substring (Delimiter)”.
  2. Click on the Add button to call up the corresponding dialog box.
  1. Enter a name for the cleansing rule in the input field “Title”.
  2. From the “Order” menu, select the appropriate option. You can choose between:
    • Before transformation: The attribute value modification also affects the supplier attributes.
    • After transformation: The attribute value modification only affects the iPIM Supply attributes.
  3. From the “Attribute” menu, select the iPIM Supply attribute to which the extracted text parts are to be allocated.
In this configuration, text parts that are located between two commas are extracted. For example, the text part “Part 2” is extracted from a supplier attribute value such as “Part 1, Part 2, Part 3”, in order to allocate it to the iPIM Supply attribute “Random attribute (277)”.
  1. Possibly enter a short description in the input field “Description”.
  2. Possibly tick the “Activate rule” checkbox to activate the rule.
  3. Possibly tick the checkbox “Internal rule” to specify that the cleansing rule is an internal rule. Internal rules can be used as subordinate rules for certain rule types such as “Conditional attribute setting”.
  4. In the input field “Start delimeter”, possibly enter the delimeter that is located directly in front of the text part that is to be extracted.
  5. In the input field “End delimeter”, possibly enter the delimeter that is located directly after the text part that is to be extracted.
  6. Possibly configure a test run and carry it out in order to check if the configuration of the rule is valid.
  • In order to finish the configuration, click on the Save button. If the process was successful, a corresponding message will appear. The cleansing rule of is now set up.
  • In order to cancel the process, click on the Cancel button.