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 Name | Can Be Renamed |
---|---|
the text | Yes |
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 |
---|---|---|---|
| The text that represents a number which needs to be converted. |
| 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.
Characters | Numeric Equivalent |
---|---|
O, o | 0 |
!, I, i | 1 |
E | 3 |
S, s, $ | 5 |
T, t | 7 |
B | 8 |
€ | 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.
Updated 29 days ago