Number from Text

This column type allows you to extract a number value from a text column, to create a new number column.

Text

Select the text column that also contains numerical values.

Location

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.

Type

Decimal = a numerical value

Hexadecimal = convert from a hexadecimal to a number

Related Articles