In two tables I have a field that contains 7 pieces of data (using a pipe as the delimiter) in one field. I want to explode this out into 7 seperate fields. The format is something like ...