Re: losing-end-of-row values when manipulating CSV input

2011-07-13 Thread Marco Nawijn
On Jul 13, 10:22 pm, Neil Berg wrote: > Hello all, > > I am having an issue with my attempts to accurately filter some data from a > CSV file I am importing.  I have attached both a sample of the CSV data and > my script.   > > The attached CSV file contains two rows and 27 columns of data.  The

Re: losing-end-of-row values when manipulating CSV input

2011-07-13 Thread Neil Berg
Ethan, Thank you for this tip- you are correct that I saved the data as rich text. I remade the files in VI instead of TextEdit, which allowed me to write a true csv file and the script works as expected now. Thanks again, Neil On Jul 13, 2011, at 2:17 PM, Ethan Furman wrote: > Neil Berg w

Re: losing-end-of-row values when manipulating CSV input

2011-07-13 Thread Ethan Furman
Neil Berg wrote: Hello all, I am having an issue with my attempts to accurately filter some data from a CSV file I am importing. I have attached both a sample of the CSV data and my script. The attached CSV file contains two rows and 27 columns of data. The first column is the station ID "B

Re: losing-end-of-row values when manipulating CSV input

2011-07-13 Thread Marco Nawijn
On Jul 13, 10:22 pm, Neil Berg wrote: > Hello all, > > I am having an issue with my attempts to accurately filter some data from a > CSV file I am importing.  I have attached both a sample of the CSV data and > my script.   > > The attached CSV file contains two rows and 27 columns of data.  The

losing-end-of-row values when manipulating CSV input

2011-07-13 Thread Neil Berg
Hello all, I am having an issue with my attempts to accurately filter some data from a CSV file I am importing. I have attached both a sample of the CSV data and my script. The attached CSV file contains two rows and 27 columns of data. The first column is the station ID "BLS", the second