Remove text at the beginning and end of a field with a non-standard middle
Posted on 2012-03-22
I'm working on a report that needs to make use of a field that contains the following text:
CTMR 7.3 John Smith 212845
CTMR 2.2 Jane Smith 212845
GRPV 7.3 John Doe 212845
MEMP 2.2 Jane Doe 212845
The only part of this field I need is the first and last names in the middle but they are of non-standard length and vary with every employee. The text to the left of the name is a system environment and the numbers are the far right are an identifier unique to them.
How would I go about stripping this field down to just say John Smith, etc?
Thanks in advance for any assistance you can provide,