Importing data into RevDB

J. Landman Gay jacque at hyperactivesw.com
Fri Dec 4 17:14:17 EST 2009


David Coker wrote:
>> set the linedelimiter to comma
>> set the itemdelimiter to quote
>> repeat for each line theLine in theCSV
>>   put item 1 to -1 of line theLine into theData
>>   --do stuff with data here
>> end repeat

> That is an awesome idea, well worth pursuing...

Be careful if there are embedded commas inside each quoted section. It 
will fail for cases like this:

"one","two,three","four"

-- 
Jacqueline Landman Gay         |     jacque at hyperactivesw.com
HyperActive Software           |     http://www.hyperactivesw.com



More information about the Use-livecode mailing list