VALUE

The VALUE Function

Function Group: Text

VALUE converts numbers in string format into numbers.

Syntax

VALUE(arg1)

• arg1 is a string of a recognizable number

Uses

If we receive a response containing driving data, like that shown below:

{  
   "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)

Which returns 18.