Number

The function Number() takes a String ¹⁾ and returns a number.
It is possible to convert a string into a certain data type by specifying the data type as a second parameter in order to perform arithmetic operations using XPath.

Typ	Description
G	Integer
d	double
D	Decimal
f	Float

Syntax:

Number('String')

Number(@Number, 'd')

Number('String', 'Datentyp')

Number('String', 'Datentyp', 'Culture')

Sample:

Code	Result	Values Type
Number('123', 'G')	123	Integer
Number('10,5', 'd')	10.5	Double
Number('10.5', 'd', '')	10.5	Double ²⁾
Number('1.000,5', 'd', 'de-de')	1000,5	Double ³⁾
Number('1,000.5', 'd', 'en-US')	1000,5	Double ⁴⁾

¹⁾

The string must necessarily be able to be converted into a numeric value, otherwise the function throws an error.

²⁾

Read with the InvariantCulture

³⁾

Read with the German notation

⁴⁾

Read with the American notation