#### The function PARSE_NUMBER converts a String containing numeric digits into a Number.

This function accepts a String and parses any numeric digits into a Number. If a Number cannot be parsed from the String, then zero is returned. Any non-numeric characters in the String are ignored.

### Declaration

PARSE_NUMBER(string_containing_a_number) -> parsed_number

### Parameters

**string_containing_a_number**(required, type:*string*)- The string to parse the number from.

### Return Values

**parsed_number**(type:*number*)- The resulting number.

### Examples

Although capable of much more, when given a string that contains a number, PARSE_NUMBER will return the number.

PARSE_NUMBER("299792458") -> 299792458

The PARSE_NUMBER function will ignore additional characters between numbers such as thousandths

PARSE_NUMBER("299,792,458") -> 299792458

The PARSE_NUMBER function will interpret a period character (**'.'**) as separating the decimal portion of the number.

PARSE_NUMBER("") ->

### Discussion

Unlike other parsing functions, while the PARSE_NUMBER function is spiritually the opposite of the FORMAT_NUMBER function, this relation is not exact. For example, the PARSE_NUMBER function cannot parse exponential notation that the FORMAT_NUMBER function generates.

PARSE_NUMBER("1e-2") -> 1

Another difference is that the PARSE_NUMBER function is locale un-aware. If a number has been formatted with a European locale that uses periods for thousandths groupings, and commas to separate the decimal, the PARSE_NUMBER will return an incorrectly interpret the first period as a decimal separator.

PARSE_NUMBER("299.792.458") -> 299.792