Thread: Parse coordinates in Word
View Single Post
 
Old 08-21-2016, 03:45 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Lat/Lon coordinates (which is what these appear to be) can be negative on either side and span +/- 0-179.9999999999999 degrees. Your coordinates also appear to be limited to a 15-digit precision, so the more digits you have for the integer part, the less you have for the decimal part. Given those parameters, your wildcard Find/Replace expression should probably be:
Find = ([\-0-9.]{16,17}) ([\-0-9.]{16,17})
Replace = [\2,\1]

Note: I've assumed your coordinates have trailing 0s
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote