Right, and when I tried it on a sample containing three files, it worked perfectly on the first line, but on the second two, it grabbed the 7th column as well. It looks like this is definitly taking me in the right direction. I'd tried the split route first but the spaces in the filename would throw everything off. I'll play around with some of these suggestions and see what I can come up with. Thanks for the quick responses.

Update: I tried the updated line and it worked beautifully, need to do some more testing, but I think I've got a winner here. Thanks again.