That's a good idea about deleting the columns, but I think this has to be completed automated so it will be able to pull the files from their locations, perform the functions needed, and then probably upload them to the desired location. I'm not sure though. Do you have some links to any examples of splitting the contents of csv files btw? Thanks for the reply.