VALUE

VALUE converts numbers in string format into numbers.

Function category: Text

Syntax

VALUE(arg1)

Arguments

Description

arg1

String of a recognizable number.

Example

Example 1: Convert data to a numerical value

If we receive the following response containing driving data:

{
"data":{
"driver_stats":{
"driver_1":{
"avg_mpg":"18",
"top_mpg":"22"
},
"driver_2":{
"avg_mpg":"16",
"top_mpg":"20"
}
}
}
}

If we'd like to convert some of the mileage data to a numerical value, we can use VALUE:

VALUE(data.driver_stats.driver_1.avg_mpg)

This returns the following:

18