View Single Post
Old 04-06-2007, 09:54 AM   #9
redmarkYankees
All Star Starter
 
redmarkYankees's Avatar
 
Join Date: Nov 2003
Posts: 1,283
Quote:
Originally Posted by battists View Post
As I suspected, I think Excel is responsible. Sometimes when you save Excel as CSV, it will add additional characters, like quotations.
The root cause isn't Excel , it's the original export function: it puts an ASCII character '9' (TAB) in several places in the header line (immediately before the headers 'options used', 'steal', 'sac bunt', 'HBP', 'GB%', 'Catcher Arm', 'PExp', '2bExp' and '3bExp'). Excel 'correctly' then puts quotes around those when saving as csv.

A small bug, unless those char-9s are needed for any real reason.
__________________
In times of universal deceit, telling the truth will be a revolutionary act.
George Orwell

Last edited by redmarkYankees; 04-06-2007 at 09:58 AM.
redmarkYankees is offline