Field extracts value from another text field

[shinichi_nguyen]

:banghead:


Hi
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

Note: I have to use the [space] for " " since it won't show when I review my post.
So the field Weight should contain the value 6T, 52T, 40T, 1T only
Can someone help me extract those values?
Much appreciate

 

[pbaldy]

Check out the InStrRev() function to find the last space, along with the Mid() function.

 

[plog]

You would use a combination of the InstrRev function (http://www.techonthenet.com/access/functions/string/instrrev.php) to find the last space in a string. Then the Mid function (http://www.techonthenet.com/access/functions/string/mid.php) to extract a substring starting at that position InstrRev identified.