CSV Files

[Bob Sneidar]

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 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
> 
> 
> _______________________________________________
> 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