I have a csv with a list of the world sea ports and their coordinates.
The coordinates are in this format:
How can i convert this to decimal Latitude / Longitude ?
Seems to be http://en.wikipedia.org/wiki/UN/LOCODE
Coordinate syntax explained in http://www.unece.org/fileadmin/DAM/cefact/locode/Service/LocodeColumn.htm#Coordinates
I assume the data is in DDDMM format.
So you have to divide the value by 100, and the fractional part by 0.60 to get decimal degrees.
The result is inside England, but away from the shore:
At least the name Astley Abbots is right.