MID

The MID Function

Function Group: Text

MID returns a segment of a string.

Syntax

MID(arg1, arg2, arg3)

• arg1 is a string to be segmented
• arg2 is the position to begin slicing the string at
• arg3 is the number of characters to slice from the string

Uses

Let's say we're given a response with an id:

{  
   "data":{  
      "ids":{  
         "id_1": "1anb4amca051"
      }
   }
}

If we are only interested in the middle 6 digits of the id, we can get them with MID:

MID(data.ids.id_1, 4, 6)

This would return b4amca

Notes

The second argument is inclusive, meaning the character at the specified position will be included in the segment.

Additionally, if the number of characters from the starting position (arg2) is less than the number specified in arg3, all available characters after the starting position will be returned.