|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: GISList: html to dbf |
| Date: |
06/10/2002 07:58:40 AM |
| From: |
Robert Heitzman |
|
|
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>
>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
>
>This file is a part of a big file about the earthquake seismicity. As you
>see there are
>two columns, lat and long, which are interested in me,in this table.I want
>to convert
>the values in the lat column and long columns to decimal degrees in Excel.
>How can I
>convert the values to decimal degress in Excel? How can I arrange formulae,
>syntax and
>strings in Excel.
>
>Best regards.
>KT
>
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! - Official partner of 2002 FIFA World Cup
>http://fifaworldcup.yahoo.com
>
>
>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/
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
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!
|
