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
