antiskeptic
Programmer
Hopefully this is a quick question....
The field I need to analyze has data that looks similar
to this:
Accounting\NSF\2000 Logs\Jan
Basically, as you can probably guess, this is
a folder path. And I need to isolate the individual folders. What I am trying to do, is group another field (the user's name) by the "common denominator" folder.
FOr example:
Accounting\ JDoe Owner
Accounting\NSF\ JDoe Owner
Accounting\NSF\2000 Logs\ JDoe Owner
Accounting\NSF\2000 Logs\Jan JDoe Owner
Accounting\NSF\2000 Logs\Feb JDoe Owner
Accounting\NSF\2000 Logs\Mar JDoe Owner
All I care about seeing, in my finished query, is the top line...because we know that JDoe owns the topmost folder, so he obviously owns all folders inside it. ( This is not exactly true in the real world...but it's good enough to get my point across, I think.
) I hope this makes sense...and if not please post any questions that will help you to help me. 
Thank you in advance for any help ayone can provide.
Sincerely,
Antiskeptic
The field I need to analyze has data that looks similar
to this:
Accounting\NSF\2000 Logs\Jan
Basically, as you can probably guess, this is
a folder path. And I need to isolate the individual folders. What I am trying to do, is group another field (the user's name) by the "common denominator" folder.
FOr example:
Accounting\ JDoe Owner
Accounting\NSF\ JDoe Owner
Accounting\NSF\2000 Logs\ JDoe Owner
Accounting\NSF\2000 Logs\Jan JDoe Owner
Accounting\NSF\2000 Logs\Feb JDoe Owner
Accounting\NSF\2000 Logs\Mar JDoe Owner
All I care about seeing, in my finished query, is the top line...because we know that JDoe owns the topmost folder, so he obviously owns all folders inside it. ( This is not exactly true in the real world...but it's good enough to get my point across, I think.
Thank you in advance for any help ayone can provide.
Sincerely,
Antiskeptic