Convert Text to Number

Convert a text representation of a number into its numeric value.

Overview

This operation takes a text representing a number and converts it into a numeric value. It also recognizes and converts certain characters that resemble numbers, ensuring accurate interpretation of numeric values, including those written in European notation or with unconventional characters. See the notes for details.

Syntax

the text is "{input}"
get the text as a number

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data NameCan Be Renamed
the textYes

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter

Description

Examples

Required

input

The text that represents a number which needs to be converted.

  • "100"
  • "3.14"

Yes

Examples

1. Converting a Whitespace-Affected Number Text

the value is "  98  "
get the value as a number
98

2. Converting a Decimal String to a Number

the decimal is "3.14"
get the decimal as a number
3.14

Notes

Additional Character-to-Number Mappings

This table defines additional character-to-number mappings, extending the standard set of conversions. It includes common characters and symbols that are translated to their corresponding numeric values.

CharactersNumeric Equivalent
O, o0
!, I, i1
E3
S, s, $5
T, t7
B8
6

European Decimal Notation

This operation properly parses decimal numbers in European notation, where commas are used as decimal separators. It automatically converts numbers like "12.345,67" into the format "12345.67" for processing.