apoc.number.parseFloat

Function

apoc.number.parseFloat(text String, pattern String, language String) - parses the given string using the default system pattern and language to produce a double.

Signature

apoc.number.parseFloat(text :: STRING?, pattern =  :: STRING?, lang =  :: STRING?) :: (FLOAT?)

Input parameters

Name Type Default

text

STRING?

null

pattern

STRING?

lang

STRING?

Usage Examples

RETURN apoc.number.parseFloat('12,345.67') AS output;
Table 1. Results
output

12345.67

RETURN apoc.number.parseFloat('12.345,67', '', 'it') AS output;
Table 2. Results
output

12345.67