num

Purpose

Converts a string or text value to a number.

Syntax

num(string)

Arguments

Requires a single argument of a string or text value.

Returned Value

Numerical value that is the extracted number.

If the input value is null, a null value is returned.

Examples

Expression

Returned Value

num("1234")

1234.0

num("6.08")

6.08

num("one thousand")

1000.0