Using 'Replace' Function in Python
<p>I have an access table that has a bunch coordinate values in degrees minutes seconds and they are formatted like this:</p>

<p>90-12-28.15</p>

<p>I want to reformat it like this:</p>

<p>90° 12' 28.15"</p>

<p>essentially replacing the dashes with the degrees minutes and seconds characters and a space between the degrees and minutes and another one between the minutes and seconds.</p>

<p>I'm thinking about using the 'Replace' function, but I'm not sure how to replace the first instance of the dash with a degree character (°) and space and then detect the second instance of the dash and place the minute characters and a space and then finally adding the seconds character at the end.</p>

<p>Any help is appreciated.</p>

<p>Mike</p>
