reading CSV text file

Jim Ault JimAultWins at yahoo.com
Sat Jun 23 01:47:32 EDT 2007


There are also commas between quotes.
This means that embedded quotes and commas are part of the string data and
need to be preserved.

eg.  "chain, gold, 12", hook clasp","out of stock",0,36.00, 79.99

Jim Ault
Las Vegas


On 6/22/07 10:19 PM, "Stephen Barncard" <stephenREVOLUTION at barncard.com>
wrote:

> That won't work; there's commas within the quotes. See my previous post.
> 
> 
>> Hi,
>> 
>> Not sure what you are asking? Do you want to know how to get rid off
>> the quote characters?
>> If so, just do this on the line that is read in:
>> 
>> replace quote with empty in myCSVLine
>> 
>> Then just break off all the fields using "," as the delimiter as in:
>> 
>> put item 1 of myCSVLine into myNameOfField1
>> put item 2 of myCSVLine into myNameOfField2
>> put item 3 of myCSVLine into myNameOfField3
>> 
>> Hope this helps
>> All the Best
>> Dave
>> 





More information about the use-livecode mailing list