LEFT

LEFT returns the leftmost segment of a string, as specified by a segment position argument. The segment position is  counted  from left to right. 
Function category: Text​
To get characters from the right side of a string, use RIGHT.
Syntax
LEFT(arg1, arg2)
Arguments
Description
arg1
String to be segmented.
arg2
Optional. Position where to segment the string. Default is 1.
Example
Let's say we're given the following response that includes an id string.
{
  "data": {
    "ids": {
      "id_1": "1anb4amca051"
    }
  }
}
If we are only interested in the first 5 digits of id_1, use the following function.
# Find 5 digits starting from the left
LEFT(data.ids.id_1, 5)
​
# Returns 1anb4

KEY.PUB

LEN

Last updated 1 year ago

Arguments	Description
arg1	String to be segmented.
arg2	Optional. Position where to segment the string. Default is 1.