This column type allows you to extract a number value from a text column, to create a new number column.
Select the text column that also contains numerical values.
Select the location of the numeric value you want to extract from the text column. There are three ways you can specify how to extract values.
- First – Extracts the first consecutive number
- After – Extract the first number after a specific text string
- Range – Extracts a fixed range of characters
Here is an example where the same text column is parsed in three different ways.
Decimal = a numerical value
Hexadecimal = convert from a hexadecimal to a number