VB.net Instr and Left usage

Good Day
Experts:

I am working with VB.net and am looking for help on the most efficient way to do the following:

Filename ---> Test.sql
Username ---> Bob

I need Filename to be TestBob.sql.  

So far I have:
DotLoc = InStr(Filename, ".")
Filename = Left(Filename, DotLoc - 1)
Filename = Filename + Username + ???

But I could not figure out the best way to get the remaining characters after the Dot(.).  Here is what I came up with but it seems like there could be a better way.
Dim Length as Integer = 0
Dim Extension as String = ""
Length = Len(Filename)
Extension = Right(Filename, (Length-(DotLoc - 1))

Thanks,
jimbo99999



Start Free Trial