How to Extract Pack Quantity from Text

Task

The pack quantity is inside text, for example Box, pack 12 pcs. The output table needs pack_qty.

Short answer

Create pack_qty and keep the number before pcs or units with \d+(?:[,.]\d+)?(?=\s*(?:pcs?|units?)).

How to Do It in Eofferix

1. Open the settings of the output pack_qty column.

   

2. In Transformations, add \d+(?:[,.]\d+)?(?=\s*(?:pcs?|units?)) with Remove everything except.

   

3. Save the column settings and go to the Export step.

Before / After