We have MID()
With Google Apps Script, there’s a function called SubString() - which is almost exactly the same thing as MID
I actually assumed this was how MID() worked (I’ve never used it), I was surprised to find that I had to specify the number of characters.
As always, thanks for considering