apoc.number.parseFloat

Function

apoc.number.parseFloat(text STRING, pattern STRING, language STRING) - parses the given STRING using the given pattern and language to produce a FLOAT.

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