Hi Brian,
Thank you for attaching the file. It is a text file. You can use a text editor to open it and see that the data it contains is not comma-separated. This old format relied on the position of characters in each row of the file to identify data -- computer programs can read it, but it's harder for us humans to parse.
There is something wrong with the format of this file, but it's hard to tell what the problem is. Sometimes the position of characters in the first row is wrong. You can find a description of the format in the TMY2 Users Manual here:
www.osti.gov/biblio/87130/. Table 3-1 describes the header row.
You might see if you can get the data from the original provider in a different format.
Best regards,
Paul.