On these drones, precise camera positions are written to a text file (.mrk)
Unfortunately, the coordinates are not written cleanly with a header, but rather with text added to each value.
For example, an image will have the coordinate values "36.0138568743,Lat -115.2255755428,Lon 794.088,Ellh".
How are others converting this to a .csv to import as a camera reference file into MS? It is easy enough to delete or exclude columns in the .mrk file that are not needed. But how to remove the text at the end of each coordinate value, e.g. ".Lat" without doing it one by one. Perhaps it can be done with a python script?
Sample file attached.
Thank you!
Dave