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, "."))
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, "."))
Used Replace(varFileName, ".txt", "") instead.
you can use:
Left(varFileName, InStrRev(varFileName, ".") -1)
InStrRev returns the position counting from left, not from right.