Instr <> IndexOf

[Tim_Parnell]

I disagree with you on this. The 0-based consistency makes programming much more straightforward.

Here’s another thread where we derailed a little bit and got into a discussion about 1-vs-0:

Mid versus IndexOf

Here’s the logic I used to convince Geoff that Middle should be 0-based. It was originally 1-based in the first API2 versions. If I’m trying to parse something like Var Target As String = "Key=Value", I can use Var KeyLen As Integer = Target.IndexOf("=") which gives me 3. This is conveniently also the number of characters I need to skip to find the equal sign. And what does Left need? A number of characters. So I can do Var LeftPart As String = Target.Left(KeyLen). Now to get the right side, I …