Importing data into RevDB

Thomas McGrath III mcgrath3 at
Tue Dec 8 08:02:34 EST 2009

Great work, David. Thanks for keeping us up to date on this.

Tom McGrath III
Lazy River Software
3mcgrath at

iTunes Library Suite - libITS
Information and download can be found on this page:

On Dec 8, 2009, at 7:53 AM, David Coker wrote:

> Hello folks,
> While this message isn't specifically about a Rev solution per se, I  
> think that some of you may still find it helpful. After a lot of  
> research on the net, I finally found a "one-two punch" to help clean  
> up this large mass of CSV data that I've been working with. As  
> always, I recommend that you work with a copy of your data file,  
> just to be on the safe side.
> To rid yourself of embedded line feeds and carriage returns using  
> Excel (untested on Mac):
> 1. Select the data you want to clean, then open up the "Find and  
> Replace" dialog.
> 2. While holding down the ALT key, type in the ASCII equivalent for  
> the character you want to replace. (e.g. Tab = 009, LF = 010, CR =  
> 013)
> 3. Replace with whatever you wish or nothing.
> The second thing I found after a lot of research is a very  
> inexpensive program for the PC, called CSV Easy, which will clearly  
> flag problematic data rows, identifying each of the problems.
> Using both of the above, I was able to locate and repair over 8000  
> problems in a file with 87000+ records (10%), which previously I  
> have been unable to do otherwise. Hopefully I will now be able to  
> convert the data into tabbed format for use in Rev for additional  
> processing.
> Best regards,
> David C.
> _______________________________________________
> use-revolution mailing list
> use-revolution at
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:

More information about the use-livecode mailing list