Login / Sign up
Data transformation

How to split rating and review count from one cell

2026-06-20
Task

A table contains a value such as 4.8 (120 reviews). The result needs separate rating and reviews_count columns.

Short answer

Create two output columns from the same source field: keep the decimal rating in one column and the number after the opening bracket in the other.

How to do it in Eofferix

  1. Upload CSV or XLSX and open the table editor.
    Rating and review count split in the Eofferix table editor
    The table shows two output columns built from one source field.
  2. Create rating from rating_text and keep only the rating number with a regular expression.
    Rules for extracting rating from a text cell
    The rating column keeps only the rating number.
  3. Create reviews_count from rating_text, keep the ( plus number fragment, then remove (.
  4. Save the template and test several rows with different review counts.

Before / after

The data below is a training example and does not belong to real user files.

Before

source data
skurating_text
SKU-10014.8 (120 reviews)

After

result
skuratingreviews_count
SKU-10014.8120

Process data faster with Eofferix

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

Sign up