I am working in a tabular set (.dbf) In ArcGIS 10.1 with an odd DMS format.The format is as follows:
Lat: 45585400 Long: 89560600
I believe this is a strange notation for 45°58'54" and -89°56'06". My problem is I can't figure out how to parse the Degrees, Minutes and Seconds out into individual fields in the .dbf. Once I get that far I can easily convert the value to decimal degrees and create point data out of it.
If anyone can help me with this I would really appreciate it.