Number Format Conversions

Functions for number format conversions

Qualified Name Type

apoc.number.format(number ANY, pattern STRING, language STRING) - formats the given INTEGER or FLOAT using the given pattern and language to produce a STRING.

Function

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

Function

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

Function

Examples

The following formats a double value using the default system pattern:
RETURN apoc.number.format(12345.67) as value;
Table 1. Results
Value

12,345.67

The following formats a double value, using . as thousand separator, , as decimal separator, rounding down:
RETURN apoc.number.format(12345, '#,##0.00;(#,##0.00)', 'it') as value;
Table 2. Results
Value

12.345,00

The following formats a double value, using . as thousand separator and , as decimal separator:
RETURN apoc.number.format(12345.67, '#,##0.00;(#,##0.00)', 'it') as value;
Table 3. Results
Value

12.345,67

The following parses a formatted value as an int:
RETURN apoc.number.parseInt('12.345', '#,##0.00;(#,##0.00)', 'it') as value;
Table 4. Results
Value

12345

The following parses a formatted value as a float:
RETURN apoc.number.parseFloat('12.345,67', '#,##0.00;(#,##0.00)', 'it') as value;
Table 5. Results
Value

12345.67

The following formats a non numeric value:
RETURN apoc.number.format('aaa') AS value;
Table 6. Results
Value

null

The following parses a non numeric value:
RETURN apoc.number.parseInt('aaa') AS value;
Table 7. Results
Value

null