AnsweredAssumed Answered

Does anyone have a script to batch process changing Deg. Min. Sec. of lat/long into Deciamal degrees….?? I.e. will be 123°46’56” to 123.78222222°. I have about 60 to 70 rows in multiple file.

Question asked by alexw2008 on Apr 21, 2017
Latest reply on Apr 21, 2017 by alexw2008

Does anyone have a script to batch process changing Deg. Min. Sec. of lat/long into Decimal degrees….??

For Example I have 123°46’56” to 123.78222222°. I have about 60 to 70 rows in multiple files. The content of the file looks like this...... 

 

61 12 44.4N 109 58 34.9W
62 18 02.1N 108 58 58.5W
63 10 48.9N 108 09 10.8W
64 13 07.0N 107 01 47.5W
64 37 51.2N 106 23 07.2W
64 46 07.3N 106 10 24.7W
64 00 17.5N 105 47 54.9W
64 05 05.0N 105 40 14.9W
65 17 50.5N 105 22 36.3W
65 35 10.7N 104 58 21.5W
65 44 58.9N 104 44 30.4W
65 57 28.9N 104 23 58.0W
65 19 09.4N 103 47 48.5W
65 27 02.8N 103 34 50.2W
65 38 48.0N 103 18 50.9W
65 06 27.6N 102 41 18.8W
66 13 55.7N 102 11 37.1W
66 31 26.8N 100 59 22.3W
66 39 52.2N 100 33 28.5W

Outcomes