Rule box category Edit text

The category Edit text contains all rule boxes that can help you edit text values. Using the rule boxes in this category, you can perform a variety of tasks, such as change text capitalization, remove emojis and repeating words, use keywords to predict categories, work with HTML tags, and translate Google categories.

This category can be divided into several subgroups. In the following sections, you can find how to use the rule boxes of the Edit text category:

The Edit text rule box category contains the rule boxes Capitalize Words, Lowercase, Uppercase, and Uppercase to human to let you modify the capitalization of words in your text values.

The Capitalize Words rule box edits your text values by capitalizing every word or only the first word in a text. If needed, it can also convert other capital letters in your text values into lowercase.

You can use the Capitalize Words rule box to remove the camel case, such as brownShoesWithBuckle, from your texts. However, this rule box doesn't add spaces between words when removing the camel case. For this purpose, we recommend using the Separate Words rule box instead. See Separate Words.

For example, you have the following values in the description attribute and want to capitalize all words in the texts without removing capital letters within words. You can achieve this with the Capitalize Words rule box by selecting LEAVE UPPERCASE as the capitalization method:

The Lowercase rule box edits your text values by converting all capital letters to lowercase.

For example, you have the following values in the description attribute and want to make all your text lowercase. You can achieve this with the Lowercase rule box:

The Uppercase rule box edits your text values by converting them into all capital letters.

For example, you have the following values in the description attribute and want to capitalize all the text. You can achieve this with the Uppercase rule box:

The Uppercase to human rule box edits your text values by converting all words in uppercase to the title case. A word must be over 3 characters long and contain only capital letters for the rule box to change its capitalization.

For example, you have the following values in the description attribute and want to convert all-caps words to lowercase but capitalize their first letters. You can achieve this with the Uppercase to human rule box:

The Edit text rule box category contains the rule boxes Replacement, Replacement Sensitive, and Taxonomy Mapping to let you replace words or phrases in your texts using lists. See Use lists for more information on these rule boxes.

See Lists feature for more information on available list types.

The Edit text rule box category contains the rule boxes Remove Duplicate Words, Remove Emojis 👍🏻, Convert HTML Linebreaks, and Sanitize HTML to let you remove unnecessary content from your texts.

The Remove Duplicate Words rule box edits your text values by deleting repetitive terms and preserving only the first mention of a term in the value.

For example, you have the following values in the sizes attribute and want to remove all repeating sizes. You can achieve this with the Remove Duplicate Words rule box by entering a comma and a space character (,) as the delimiter:

In the second row, XXL stays twice because you use a comma and a space (,) as a delimiter. The platform considers terms in between these delimiters. Thus, the terms XXL and and XXL aren't duplicates.

The Remove Emojis 👍🏻 rule box edits your text values by deleting emojis.

For example, you have the following values in the description attribute and want to delete all emojis. You can achieve this with the Remove Emojis 👍🏻 rule box:

The Convert HTML Linebreaks rule box edits your text values by separating them into paragraphs at the HTML tag <br/>. To separate your texts into paragraphs, you should first add <br/> tags within your values where you want new paragraphs to start.

For example, you have the following values in the description attribute and want to separate them into paragraphs using <br/> tags. You can achieve this with the Convert HTML Linebreaks rule box:

The Sanitize HTML rule box simplifies your HTML values by removing all HTML tags and tag attributes except for the standard formatting tags, such as a, b, sup, sub, em, strong, p, br, hr, h1, h2, h3, h4, h5, h6, ul, ol, li, div, table, thead, tbody, tfoot, tr, th, td, colgroup, and blockquote.

For example, you have the following values in the description_html attribute and want to remove excessive tags and tag attributes from these HTML bodies. You can achieve this with the Sanitize HTML rule box:

The Edit text rule box category contains these rule boxes:

The Merge Values by Delimiter rule box finds delimiter-separated items in the values of two chosen attributes, rearranges them, and assigns the rearranged items in the current attribute, separating them with a desired delimiter. See the rule box setup example to understand how the rule box rearranges delimiter-separated items.

For example, you have the following values in the sizes and items_in_stock attributes and want to display stock levels per each size in stock_per_size. You can achieve this with the following setup of the Merge Values by Delimiter rule box:

If the attributes you choose in the rule box setup don't contain any data, the rule box assigns an empty value or, if provided, the text from the input field at the bottom of the rule box.

If the delimiters entered in the rule box setup don't exist in the chosen attributes, the rule box doesn't work as expected.

The Categorize by Keywords rule box uses a replacement list to assign a category based on the keywords found in the needed attribute, such as description or title. This rule box can be useful if you don't need categorization for any specific classification system but want to create your categories based on the existing product titles or descriptions. The rule box can scan large texts to find the keywords and assign a corresponding category based on the highest score. The scoring rules are as follows:

For example, you want to create categories based on the existing product descriptions. You can achieve this by adding terms to the replacement lists and setting up the Categorize by Keywords rule box as follows:

In this example, the rule box replaces existing category values with the categories in the replacement list and makes values that don't match empty.

The matching and category assignment is based on the scoring rules. In this example, the category with more unique words in the text wins. Also, when the number of unique words is equal, the exact match wins. For example, the fourth row contains two matches for two categories: Long Sleeve and Dress Long. The Long Dresses category wins as the keywords match exactly the search term in the list. In case of the Long Sleeve win, the text should contain Top Long Sleeve.

Google accepts only a predefined list of values in the category attribute.

With the Translate Google Category rule box, you can translate your Google categories from one language to another. You can also change your Google categories in any language to the associated category IDs, which are the same for all languages. The rule box empties the values in those products that contain invalid categories.

For example, your category attribute contains valid Google categories for the US in English, and you need to translate them into valid Google categories in German.

If you select id in Target Format for the same use case, the rule box outputs the following: