Re: Spreadsheet_Excel_Reader problem

On Thu, Mar 18, 2010 at 8:40 AM, tedd <tedd.sperling@gmail.com> wrote: > At 11:35 AM +0000 3/18/10, Ashley Sheridan wrote: >> >> The .csv format is just a plain text format, so you won't get formatting >> or formulas in your 'sheets' (csv is also a sheetless format) but it's >> been used for years by many systems for data. >> >> A lot of database systems will let you import csv files as well, which >> is quite convenient, although you will have to make sure the csv uses >> commas to delimit the data. Microsoft managed to basterdise this format >> a bit as well, and lets you use tabs, spaces and all sorts of other >> characters to delimit data fields. Someone obviously didn't mention to >> them that the file type is 'comma separated values'! >> >> Thanks, >> Ash > > Ash: > > I remember many years ago I had a problem with M$ version of plain text csv > files -- the first cell of each spreadsheet was different than all other > cells. It took me a while to discover that difference and build in an > exception. > > I've found that M$ always has a better idea, even if they are the only ones > who think so. > > Cheers, > > tedd > > -- Personally, I find working with fixed widths is best. The text file might be larger but I don't have worry about escaping any type of characters ;) Regards, Tommy