New Formula Please: SubString()

[MultiTech_Visions]

We have MID()

• However, the third part that you enter here is the “number of characters”
  

This can be really hard to derive sometimes.

With Google Apps Script, there’s a function called SubString() - which is almost exactly the same thing as MID

• The difference is the third part that you enter is the position to stop at.

---

Can we get something where we specify the index position where to stop?

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

[MultiTech_Visions]

FYI: The solution to my problem (of finding the number of characters that I needed) was found with the following formula:

mid(
  [Ag_Report_Last_Block], 
  find(
    "*Restrictions:*", 
    [Ag_Report_Last_Block]
  ), 
  (
  	find(
    "Additional Notice Comments", 
    [Ag_Report_Last_Block]
  )
  	-	find(
        "*Restrictions:*", 
        [Ag_Report_Last_Block]
      )
  )
)