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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Left to a space? 1
Query to select individual records 4
Copy previous record into form field 0
How to query a Dataset to Return Records that contain "a thing" 5
Move Column Values to Rows - THANKS in Advance 3
Count unique with multiple criteria 3
analyze a string 2
Searching for best matches in string query 7

Top