This demonstrates one way to extract data from a field that contains JSON data (e.g. key/value pairs).
The approach using a regex to pattern match on the key and then extract the value.
// Extract the value of a key/value pair from a JSON string
// In this example we want the value of a key called highwaytype, eg:
// and tested with http://regexr.com
// Here is a variation to get the value of a float, removing a trailing comma after the value using !,:
Inputs and Setup: (for table calculations, delete if not applicable)
Partitioning and Addressing: (for table calculations, delete if not applicable)