Yak Posting Veteran
Posted - 11/08/2013 : 13:11:36
| Good afternoon, I have a table that has several fields that contain multiple user names sepearted by a ";". I am trying to extract all of the names into one column so I can then compare it against our active directory.
It would be nice if there was list of names, not duplicated.
Field1 'Mary Beth Underwood'
Field2 'Bryan Flinstone'
Field3 'Mary Beth Underwood;George Test'
Field4 'Hank String'
Field1 'Gary Strong'
Field2 'Barney Ted;George Bishop; Hank String'
Field3 'Liz What;Ted Notime'
Field4 'Henry Franks'
What I would like to see is a list like this:
Mary Beth Underwood
Thank you for your always prompt responses