New Formula Please: SubString()

We have MID()

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

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 partyparrot (Appsheet)

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]
      )
  )
)