Importing data into RevDB

Thomas McGrath III mcgrath3 at mac.com
Sat Dec 5 08:24:16 EST 2009


I'm sure others have known about this but I feel like someone just  
turned on a giant light bulb in my head. This is the single best thing  
I have learned this year...

set the linedelimiter to comma
set the itemdelimiter to quote

I am just amazed...

Tom McGrath III
Lazy River Software
3mcgrath at comcast.net

iTunes Library Suite - libITS
Information and download can be found on this page:
http://www.lazyriversoftware.com/RevOne.html


On Dec 4, 2009, at 5:02 PM, David Coker wrote:

>> normally, csv is a pain in the ass, but Rev tokens trump that ;)
>>
>> you can set the linedelimiter to comma, and the itemdelimter to  
>> quote.
>> then you could do something similar to this (great for not having to
>> make special cases for the particular field being empty, lacking
>> quotes, etc.):
>>
>> 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
>
>
> Hello Björnke,
> That is an awesome idea, well worth pursuing...
>
>> normally, csv is a pain in the ass, but Rev tokens trump that ;)
>
> I sure can't argue that point.
>
> Most of what I do with Rev involves processing text of some sort and  
> when considering the simplicity of Rev, I have yet to find anything  
> that even comes close to it for parsing text. I've found that my own  
> lack of knowledge and understanding are the weak links around here. ;)
>
> Thank you so much for the help,
>
> David C.
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the Use-livecode mailing list