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