Thanks for the comment! :o)
Jack Chastain wrote:
Of course, if you have a file that looks more like this:
Name
Address
City
State
Zip
...
then none of the above will do much for you until you first get your data
oriented in a more normalised form.
Of course, there are real Databases for this sort of thing as well. Isn't
there going to be a talk for something like that tomorrow?? ;-)
Yeah I would love to see a talk on databases with comparisons and a
introduction to Couchdb :o)
The data definitely needs to be oriented and in a more normalized form :o)
I'm trying to find the quickest way to do it. One idea is to organize
the file in the basic format it is now and then use find/replace editor
tool or sed to replace carriage returns with commas to make a CSV file.
I have also put a ~ at the end of each CSV record and used find/replace
to make it a carriage return to complete the CSV file requirement. (I
hope I'm making sense :o)
I have tried it already with success, its still quite a bit of work. I'm
giving a second try in slightly different way.
The copying, clicking and dragging inside of Exel or Open Office Calc is
a bit painful.
Not everything is in order and some have more information then others
like this:
Location
Company Name
company info
phone
email
website
Address, City, State, Zip
phone Fax
Contact
Position
phone
fax
notes
Some are:
Location
Company Name
company info
Address City State Zip
phone Fax
Contact
Position
phone
fax
company department
Contact (for department)
Position (for department)
phone (for department)
Contact(for department)
Position(for department)
phone(for department)
and variations between the two, with more or less information.
But its not that pretty
This is an example of a short address/company info that could be made in to a
record.
Bronx
Open Sauce Rox Press: (p.2)
007 Lunar-crater-icecream Rd. Poughkeepsie, NY 01010-1011
P.O. Box 010 New York, NY 10011-0010
Tel: (123)-123-3123 Fax: (123)-123-3123
Thanks!
_______________________________________________
Mid-Hudson Valley Linux Users Group http://mhvlug.org
http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug
Upcoming Meetings (6pm - 8pm) MHVLS Auditorium
Jan 7 - Ruby on Rails
Feb 4 - TBD
