Skip Navigation

Newer Version Available

This content describes an older version of this product. View Latest

string_to_number

Converts a string literal to a number literal.

Syntax

string_to_number(string)

Usage

If the string can't be parsed as a number or contains a separator, such as a comma, the query fails.

Example

1-- creates a field called "Number" that contains the number 12345
2
3q = foreach q generate string_to_number("12345") as 'Number';