Rule box category Replace values

Take the steps from Add a rule box to add the Text Replace rule box.

Enter the value you want to replace in the Search for field.

Enter the value you want to have instead of the existing value in the Replace by field. Leave the Replace by field empty if you want to remove your search term. To remove space, see Rule box category Clean up values.

In Case, select whether the matches should be case-sensitive:

Select Save.

Take the steps from Add a rule box to add the Map-Replace rule box.

Enter search value into the field. If you have multiple values, start each search value with a new line.

Add the delimiter directly after your search term to separate it from the replace value. The rule box selects Colon (:) as a default. But if the colon (:) is a part of the phrase you want to replace, you can use another delimiter. You should choose your delimiter in the List Delimiter drop-down menu.

Enter the replace value directly after the delimiter.

In Case, select whether the matches should be case-sensitive:

Select Save.

Take the steps from Add a rule box to add the Mapping rule box.

Enter search value into the field. If you have multiple values, start each search value with a new line.

Add the colon delimiter (:) directly after your search value.

Enter the replace value without spaces after the delimiter.

In Case, select whether the matches should be case-sensitive:

Select Save.

Take the steps from Add a rule box to add the Translate Google Category rule box.

In Source Format, select the current language and country of your Google categories.

Choose id if your category attribute contains category IDs instead of spelled-out category names.

In Target Format, select the language and country you want to translate your Google categories into.

Choose id if you want to transform your spelled-out category names into category IDs.

Select Save.

Take the steps from Add a rule box to add the Replace Dynamic Values rule box.

In Search Column, choose an attribute where the rule box should take the search values. The attributes listed here and their searched contents come from a previous stage.

In Replace Column, choose the attribute where the rule box takes the replace values. The attributes listed here and their searched contents come from a previous stage.

If you don't want to take values from another attribute, enter a value in the Static Value that should appear in the current attribute.

In Match Type, select the matching logic:

Select Save.

Take the steps from Add a rule box to add the Replace if Column Contains rule box.

In Column, choose the attribute where the rule box should search for a value. The attributes listed here and their searched contents come from a previous stage.

Enter the values in the following order, separating them with a colon : and following the template search column:search for replace:replace:

Select Save.

Take the steps from Add a rule box to add the Compare Columns rule box.

Select attributes you wish to compare in the Column A and Column B drop-down menus. The attributes listed here and their searched contents come from a previous stage.

In Handle match, choose the action type if there is a match between the selected attributes and enter a replace value:

In Handle no match, choose the action type if there is no match between the selected attributes and enter a replace value:

Choose an action if one of the attributes doesn't exist:

Select Save.

Take the steps from Add a rule box to add the Text Replace if Column Contains rule box.

In Source Column, select an attribute where the rule box should search for a value. The attributes listed here and their searched contents come from a previous stage.

Select the matching logic:

In the search field, enter the term you want to replace in the current attribute. The matching is case-sensitive.

In the replace field, enter the term you want to set instead of the existing term in the current attribute.

Select Save.

Take the steps from Add a rule box to add the Replace In Between rule box.

Enter the values that frame the term you want to replace in From and To. The rule box replaces the entire phrase, including the entered values.

Add a replace value into the Replace With field. You can enter spaces or punctuation marks before and after the term to separate it from the rest of the words in the string.

Select Save.

Take the steps from Add a rule box to add the Numeric Compare rule box.

In the first and second Select Option drop-down menus, select the attributes that you want to compare and select the comparison operator between them:

The attributes listed here and their searched contents come from a previous stage.

In the handle match field, enter the value you want to assign when the attribute finds a match for the comparison of two values from the selected attributes.

In the handle no match field, enter the value you want to set instead of the values in the current attribute if there is no match for the comparison of two values of the selected attributes. You can choose how to set the value:

Select Save.

Take the steps from Add a rule box to add the Convert Special Characters rule box.

Select Save.

Take the steps from Add a rule box to add the Convert Character Encoding rule box.

Select the encoding of your data in the Source Encoding drop-down menu:

Select the encoding of your data in the Target Encoding drop-down menu:

In Additional Options, select what the rule box should do in case it can't find the corresponding representation to the character in the target encoding:

Select Save.

Take the steps from Add a rule box to add the Remove UTF-8 Control Characters rule box.

In the Replace with, select what you want to get instead of the value:

Select Save.

Take the steps from Add a rule box to add the Text Template rule box.

Enter your text template in the input field.

To add a dynamic value, enter the exact name of the attribute between two curly brackets and spaces at the beginning and end of the value, such as {{ attribute_name }}.

The rule box uses the attributes and their contents from a previous stage. If the chosen attributes have any changes in their values in the same stage where you apply the rule box, the platform still uses the unchanged values as they come from a previous stage.

Select Save.

Go to Lists from your site's main menu and add all terms you need to replace to the Standard, Dynamic, or Attribute-based Replacement list. See Replacement lists to choose a required type.

Take the steps from Add a rule box to add the Text Template With List rule box.

Select use list to choose a list that contains the values you want to use in the text template.

Enter your text template in the input field.

To add a dynamic value, enter the exact name of the attribute between two curly brackets and spaces at the beginning and end of the value, such as {{ attribute_name }}.

The rule box uses the attributes and their contents from a previous stage. If the chosen attributes have any changes in their values in the same stage where you apply the rule box, the platform still uses the unchanged values as they come from a previous stage.

To refer to the values of the selected list and add them all separated with a comma and a space character (, ), use the following Twig: {{ ListValues | join(', ') }}.

Select Save.