LEN

The LEN Function

Function Group: Text

LEN returns the length of a string

Syntax

LEN(arg1)

• arg1 is a string

Uses

Let's say we're given a response with some vehicle information that looks like this:

{  
   "data":{  
      "vehicles":{  
         "vehicle_1":{  
            "driver":"Otto H. Mobile"
         }
      }
   }
}

If we want to find the string length of our driver name, we would use:

LEN(data.vehicles.vehicle_1)

This will return 14.

Notes

LEN only operates on strings.

If you try to pass it another type of object, like an array, it might yield an unexpected result. For instance, when you try to run:

LEN({1, 2, 3}) you get 1 as a response.