How to Convert mm, cm, and m to Centimeters in a Table

2026-06-20

Task

The supplier sends length in different units: 1200 mm, 80 cm, 1.5 m. The output column needs centimeters.

First keep the number. If the source contains mm, divide by 10; if it contains the separate unit m, multiply by 100; leave cm unchanged.

Open the settings of the output length_cm column.
The click is on the settings icon of the length_cm column.
Add number extraction \d+(?:[,.]\d+)?, then source-column conditions: \bmm\b → divide by 10, \bm\b → multiply by 100.
The Transformations block shows the full rule chain for this case.
Save the column settings and go to the Export step.

source data

result