I was previously skipping row 1 but now I need to extract some data out of the header.

I'll take a look at script components which I haven't used before.

The file actually does end with the delimiter (and a carriage return). I think its sourced from a old system, perhaps from the mainframe world.

Thanks