InStrRev returning unexpected results

[jgelpi16]

I have the below code and for some reason I'm getting varTableName = "CTL" as the result instead of varTableName = "CTL-DEC6TH".

varFileName = "CTL-DEC6th.txt"
varTableName = Left(varFileName, Len(varFileName) - InStrRev(varFileName, "."))

[jgelpi16]

Used Replace(varFileName, ".txt", "") instead.

[weekend00]

you can use:
Left(varFileName, InStrRev(varFileName, ".") -1)

InStrRev returns the position counting from left, not from right.