Importing data into RevDB

Thomas McGrath III mcgrath3 at mac.com
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 comcast.net

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


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.
>
> http://www.tizma.com/csveasy
>
> 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 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