|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | RE: GISList: html to dbf |
| Date: |
06/10/2002 07:58:40 AM |
| From: |
Dimitri Rotow |
|
|
> First massage the data with Word and change the dash to to spaces. Then
> Copy,Paste all the text into Excel. (You can probably do the same thing
> using Excel from the beginning.) Then use Data, Text to columns and split
> the data up into individual columns. Then calculate the decimal
> Lat/Longs by
> adding the degree columns and the decimal minutes/60.
> <snip>
Lucky for you, there is a tool that will do all this perfectly - See
Manifold Database Commander at
http://www.manifold.net/products/commander/commander_home.html
It will open HTML tables, allow you to manipulate them as Bob describes
above and then save them to an Excel, Access or other table as you desire.
Commander's Transform Toolbar makes column manipulation a snap. You can
even create an Active Column (it's like a spread sheet formula) that once
your Lat/Longs are in a sensible format will enable you to show them as
decimal degrees. The user manual has a step-by-step example that is very
similar to what you ask.
Commander is $145. There's a free downloadable Trial Edition.
Cheers,
Dimitri
> >DATE TIME LAT LONG DEPTH MAG
> >010103 1344 38.7 40-29.4 29-56.4 13.0 2.7
> >010103 1614 49.0 40-23.4 28-58.2 25.0 2.7
> >010103 2206 37.9 40-41.4 32-58.2 5.0 3.3
> >010103 2302 53.1 38-55.2 26-06.6 7.0 3.5
> >010103 2342 36.2 40-46.2 29-16.8 21.0 2.6
> >010104 0035 22.1 38-47.4 43-12.6 5.0 3.6
> >010104 0106 47.5 37-13.8 28-29.4 0.0 3.0
> >010104 0120 35.7 37-36.0 26-36.6 6.0 3.7
> >
> >
>
To unsubscribe, write to gislist-unsubscribe@geocomm.com
________________________________________________________________________
Setup a GeoCommunity Account and have access to FAST DataDownloads
and Premium Career Posting at a discounted rate!
https://www.geocomm.com/cgi-bin/accounts/login
On-line Archives available at
http://spatialnews.geocomm.com/community/lists/
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
