separating string value

D

Doug

I have a field where the data has not been normalized but
requires to be analyzed.

sample data in the field:

big bob company
joe company 1
Joe company 2

the numbers are not in every record but represent
different units for each company. the problem is I need to
group based on the company not the unit. the number can be
3 digits.

Any help would be appreciated. thanks in advanced Doug
 
Top