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

  • ,
  • .
  • (none)

-

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

  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10

-

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