CSV Files

Keith Clarke keith.clarke at clarkeandclarke.co.uk
Wed Mar 28 13:09:03 EDT 2012


...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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list