Login / Sign up
Table editor

How to Convert Milliliters to Liters in a Table

2026-06-20

Task

The volume_ml column stores volume in milliliters, for example 750 ml. The output column needs liters.

Short answer

Keep the number with \d+(?:[,.]\d+)?, then divide the value by 1000.

How to Do It in Eofferix

  1. Open the settings of the output volume_l column.
    Animation showing how to open the volume_l column settings
    The click is on the settings icon of the volume_l column.
  2. Add \d+(?:[,.]\d+)? with Remove everything except, then add Divide by 1000.
    Screenshot of transformation rules for the volume_l column
    The Transformations block shows the full rule chain for this case.
  3. Save the column settings and go to the Export step.

Before / After

Before

source data
skuvolume_ml
SKU-700750 ml
SKU-7011500 ml

After

result
skuvolume_l
SKU-7000.75
SKU-7011.5

Process data faster with Eofferix

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

Sign up