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.
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.
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
2. Converting a Decimal String to a Number
the decimal is "3.14"
get the decimal as a number
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.
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.
Last updated
Was this helpful?