Solution depends on the data consistency. It's one thing if lat is always ##space##spaceremainder (i.e. only one space) and the same can be said for long, then maybe not too difficult. Same goes for the second request, although I see you have a space in long but not lat. If you could post a data dump that shows as many variations as possible, that would help. Suggest you dump into Excel and weed out most of the similar stuff so that variations are shown. Center all the entries, and copy/paste in a post. You should get a pretty decent html table. If need be, you can "Go Advanced" here and increase the table width easily enough.
BTW: we/I appreciate you declaring this has been posted elsewhere, but etiquette suggests you post a link to any other post for this issue in each forum so we can keep tabs. Much appreciated by all if you update (mark as solved) in both places if that happens. Something like this can take hours, and speaking for myself, the last thing I want to do is spend a lot of time on something that has been or is close to being solved elsewhere.
Last edited by Micron; 05-23-2017 at 08:30 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.