Now that I think about it, a properly formatted CSV file will quote string values but not numerical values, the obvious reason being, a value may actually contain commas, so they should be quoted to prevent false terminations. Excel will not do that. Maybe that is a good thing, so long as your values do not contain commas.
Bob On Mar 28, 2012, at 10:09 AM, Keith Clarke wrote: > ...that seems to be the same for Google sheets, too - though I've not dug > into whether there is an obvious end-of-line character. > Best, > Keith.. > > On 28 Mar 2012, at 18:03, Bob Sneidar wrote: > >> I have noticed that csv exports from Excel will stop short of including all >> the columns in any given row if there is no more data, so you will get rows >> with varying numbers of columns if you have any empty "cells" at the end of >> a row. That has tripped me up a few times with other software that expects >> data to be there, even if it's an empty value. >> >> Bob >> >> >> On Mar 28, 2012, at 9:55 AM, Pete wrote: >> >>> OK, so I know CSV files are not everyone's favorite subject but sometimes >>> you have no control over how data reaches you! >>> >>> I have a handler in place that deals with the vagaries of CSV files, like >>> returns, commas, and quotes in the data (did I miss any?) but it relies on >>> a repeat loop looking at every character in the csv file. It seems to work >>> just fine but I'm wondering if the collective knowledge of this list gas >>> already come up with a more efficient solution. >>> >>> Thanks, >>> -- >>> Pete >>> Molly's Revenge <http://www.mollysrevenge.com> >>> _______________________________________________ >>> use-livecode mailing list >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
