Login / Sign up
Table transformations

How to split image URL lists into main and additional images

2026-06-20
Task

images contains several URLs separated by semicolons. The first URL should go to main_image; the rest should go to additional_images.

Short answer

Create two columns from images: in main_image, keep everything before the first ;; in additional_images, remove everything up to the first ;, then remove the separator.

How to do it in Eofferix

  1. Open the settings of main_image and select images as the source.

    main_image settings for an image URL list
    The outline shows where to open main_image settings.

  2. For main_image, add: Regular expression → ^[^;]+ → Remove everything except; then trim edges.

    Rules for extracting the first image URL
    main_image keeps only the first URL before the ; separator.

  3. Create additional_images from images: Contains substring → ; → Remove before; then Contains substring → ; → Remove substring; then trim.

    Rules for extracting additional image URLs
    These rules remove the first URL and keep the remaining URLs.

  4. Save the template and run the transformation on the final step.

Before / after

Before

source data
skuimages
SKU-100https://cdn.example/en-main.jpg; https://cdn.example/en-side.jpg; https://cdn.example/en-back.jpg

After

result
skumain_imageadditional_images
SKU-100https://cdn.example/en-main.jpghttps://cdn.example/en-side.jpg; https://cdn.example/en-back.jpg

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up