Extracting the numbers contained in a column
If you want to use the numbers contained in a column, such as the postal code in
an address, you may want to extract this numbers to a new column.
Procedure
- Select the column from which you want to extract numbers.
- In the Functions panel, type Extract Number and click the result to execute the associated function.
Results
Information noteTip: This transformation
can also be performed by using the Automatically formatting data based on examples
function.