Unfortunately, this is the simplest (generic) formula I can come up with to strip letter identifiers at the end; 
see for example http://sourceforge.net/projects/bfast/files/bfast/0.5.4/