Advanced Text to Number
Description
Converts a text field with a combination of numeric and text values into a corresponding numeric field, using the text phrase as a numeric multiplier.
For instance:
-
If K is defined as a Factor of 1000, 2K is converted to 2000.
-
If M is defined as a Factor of 1,000,000 3.5M is converted to 3,500,000.
Several predefined conversions are provided by default. Selecting the Edit 
icon to the right of a Phrase + Factor combination enables you to modify the given factor, such as by inserting commas to indicate the thousands and millions places. You can define new Phrase and Factor combinations by clicking the Add 
icon. The decimal separator to use when conversion is performed can be selected from the Decimal Separator dropdown.
The conversion factors are automatically applied when you select OK.
Input/Output Data Type
|
Input |
Output |
|
text |
number |
Example
In this example, Sale is the original text column and Sale - Converted is the converted column.
© 2024 Altair Engineering Inc. All Rights Reserved.