Summary
Converts string values into floating-point numbers.
Configuration
Input settings of existing table
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
Input columns | System.Object | opt. | Which columns are to be converted? | col1 |
Settings
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
Decimal symbol (entry data) | System.String
| - | Decimal separator of the entrance data | 12.3 30,22 |
Thousands separator (entrance data) | System.String
| - | Thousands separator of the entrance data | 1.000 1,000 |
Thousands separator (result) | System.Boolean | - | Thousands separator for the result column | - |
Places after the decimal (result) | System.String
| - | Number of decimal places to be output | 1.1 2.23 34,3332 |
Prefix of success column | System.String | - | Prefix of the result column Success/No success | Success_ |
Prefix column value | System.String | - | Prefix of the result column for the converted value | Value_ |
Max. number of errors (0=unlimited) | System.Int32 | - | Number of faulty conversions after which the operators terminates. Value 0 means no limitation. | 20 |
Want to learn more?
Screenshot
Examples
Example: Bank account
Situation | A column that stores data of the money people have in their bank accounts as string is converted into double values. |
---|---|
Settings | |
Result | |
Project-File | - |
Troubleshooting
Nothing known up to now.
Related topics
- Operators (alphabetical overview)
- Format columns 2.0
- Conversion "String -> Date 2.0"