How to split one field into multiple values

One field can contain several values: tags separated by commas, links separated by spaces, dimensions separated by semicolons.

One field can contain several values: tags separated by commas, links separated by spaces, dimensions separated by semicolons.

How to split one field into multiple values — Eofferix
Eofferix interface screenshot: How to split one field into multiple values

When to use

Splitting is needed if the recipient is expecting an array, multiple strings, multiple images, or individual characteristics.

How to set up

  1. Find a field with multiple values.
  2. Specify the delimiter by which the service should divide the string.
  3. Choose where to add the parts: into an array, repeating rows, or individual fields.
  4. Set up clearing spaces around parts.
  5. Check out examples with single, multiple, and null values.

What will happen

The service will decompose one string into separate values and transmit them in the required form.

What is important to remember

  • If the delimiter occurs within a value, choose a different splitting method.
  • For image links it is often better to use an explicit delimiter.