Several Values in One Field

How to process values stored with a separator in one table cell, JSON field, or XML value.

Use this setting when one value contains several parts: codes, tags, properties, links, or other values separated by a character.

Animation of several values in one Eofferix field
The multiple-value mode sets a separator and applies rules to each part of the value.

Example: red; blue; green. Without this setting, rules see the whole string. With the setting enabled, Eofferix processes red, blue, and green separately.

Where to Enable It

  • Open the settings of the result field, node, or column.
  • In Additional settings, enable Several values in one field. In the table editor, it is shown as Several values in one cell.
  • Enter the Value separator, for example ; or |.

How It Works

  1. Eofferix splits the source value by the configured separator.
  2. Transformation rules are applied to each part separately.
  3. Empty parts are not included in the result.
  4. The result is joined back with the same separator.

Example

Source valueRulesResult
red ; BLUE ; green Trim spaces, convert to lowercasered;blue;green
SKU-1|SKU-2|SKU-3Add prefix item-item-SKU-1|item-SKU-2|item-SKU-3

What It Does Not Do

It does not split one product, table row, or XML/JSON element into several separate elements. Use row, array, or grouping settings for structure splitting.

For Images

If the several values are image links, use the separate image setting: Several images in one field. It can select an image range and save prepared files on the service.