The company I work at started very small but has been growing at a silly rate for the last few years now. They started with a server that was sharing a few other duties and also running the SQL DBs.

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 ...