Link to home
Start Free TrialLog in
Avatar of StrawsPulledAtRandom
StrawsPulledAtRandomFlag for United States of America

asked on

Remove text at the beginning and end of a field with a non-standard middle

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,

~SPAR
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial