Number from Text

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

On This Page