Great work, David. Thanks for keeping us up to date on this.
Tom McGrath III
Lazy River Software
3mcgr...@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution