Extract numbers

Extract numerical values from a text column.

Options

Extract several values

By default, the processor extracts several values and outputs each detected number into a separate column, suffixed with the index of the number. Unselect this option to extract only the first found number.

Extract values into a JSON array

Output the found number(s) in a single column as a JSON-array.

Note

In SQL mode, the number of output columns must be fixed beforehand. It is therefore extrapolated from the sample.

Expand ‘k’ to ‘1000’ and ‘m’ to ‘1000000’

Automatically expand notations like ‘10K’ and ‘5M’

Decimal separator

Use the program’s best guess or choose from between comma and dot separators.