Using visual logic you have to shorten the string with a value. In this case I believe String Left would work. I am not in front of my machine at the moment, but will be this afternoon. I did this for Hockey Stats last season. Someone might be able to have a better answer for you by then too.
#XPression