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
input	The text that represents a number which needs to be converted.	"100" "3.14"	Yes

Examples

1. Converting a Whitespace-Affected Number Text

Automation

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

Results

2. Converting a Decimal String to a Number

Automation

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

Results

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.