knightwest
Registered User.
- Local time
- Today, 15:45
- Joined
- Apr 18, 2007
- Messages
- 16
Hello all,
I have a problem with the RIGHT function.
It all seems very simple to me, but I can't get it to work the way I want.
I have a set of fields:
RETURNED BACS - ET1685311TA
they all start with "Returned Bacs - " bit.
I thought it would be easy using the RIGHT function to just pick the bit right of the last space.
I have written this (with help from an example):
Right(Trim([text]),Len(Trim([text]))-InStr(1,[text]," ")-1)
but it is always bringing back "ACS - ET1685311TA
I know I am doing something wrong, I have played around with the formula, and as I change parameters it keeps bringing back different results, but never just the stuff to the right of the final space, which is what I need.
Any help would be much appreciated...
I have a problem with the RIGHT function.
It all seems very simple to me, but I can't get it to work the way I want.
I have a set of fields:
RETURNED BACS - ET1685311TA
they all start with "Returned Bacs - " bit.
I thought it would be easy using the RIGHT function to just pick the bit right of the last space.
I have written this (with help from an example):
Right(Trim([text]),Len(Trim([text]))-InStr(1,[text]," ")-1)
but it is always bringing back "ACS - ET1685311TA
I know I am doing something wrong, I have played around with the formula, and as I change parameters it keeps bringing back different results, but never just the stuff to the right of the final space, which is what I need.
Any help would be much appreciated...