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:
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 =
> 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
> 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:
More information about the use-livecode