I have the below code and for some reason I'm getting varTableName = "CTL" as the result instead of varTableName = "CTL-DEC6TH".
Code:varFileName = "CTL-DEC6th.txt" varTableName = Left(varFileName, Len(varFileName) - InStrRev(varFileName, "."))