Creating Multiple Records from Single Delimited Field

M

MSJ

I am working with some data that lists Supervisor Hierarchy in a Pipe
Delimited format and I want to be able to have it show in a query
based on each level of the supervisor.

Example:
Name SupervisorHierarchy
John Smith |White|Lee|Martinez|Scott|
Jim Jones |Clark|Wright|Jackson|Johnson|Hill|Lewis|

Ideally I would like to see
Name Supervisor Level
John Smith White 1
John Smith Lee 2
John Smith Martinez 3
John Smith Scott 4
Jim Jones Clark 1
Jim Jones Wright 2
Jim Jones Jackson 3
Jim Jones Johnson 4
Jim Jones Hill 5
Jim Jones Lewis 6
 
D

Duane Hookom

Is there a maximum number of values in the SupervisorHierarchy field? Do you
have a table of every unique last name? What happens if two people have the
same last name?
 

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

Multiple records in table to display single records 7
how do I create supervisor hierarchy with the access table 2
Concatenate multiple records 3
Adding a Contact with multiple e-mail addresses to a Distribution 12
Sorting Problem 1
50% formula 2
Count with 1 variable & 1 constant criteria formula 3
copy data for match word from one file to another file 1

Top