Queries :: Field Extracts Value From Another Text Field

I'm building a query from tables and there is a field i called it: Weight, that should contain the value from the Description field. The Description field is a text field and it always end with the format as --T, with -- as number, and it can be either 1 or 2 digits, no more.

For example: 2T, 48T, 2T, 36T

So, the whole Description field value is always like this: Bla bla bla 2T, OR: heheheheh 24T

The thing is before the --T, sometime people put in 1 space, 2 spaces or multiple spaces, for example:

This is a test [space]6T
This is a difficult test [space][space] [space] [space] 52T
This is an easy test [space] [space] [space] [space] [space] 40T
I hate taking test [space] [space] 1T

So the field Weight should contain the value 6T, 52T, 40T, 1T only