CSV Files

Bob Sneidar bobs at twft.com
Wed Mar 28 13:03:25 EDT 2012


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





More information about the use-livecode mailing list