Parse coordinates in Word

[stephanberger4]

I've got this document with thousand of line of coordinates points like that :


166.367255491767 -22.3247832117284
166.367461004327 -22.3248066556704
I want to change the format and like, as a result, something like that :
[-22.3247832117284,166.367255491767]
[-22.3248066556704,166.367461004327]
Do you know a way to do so, automatically with Microsoft Word ?
Thanks,

[gmayor]

A macro isn't necessary. Replace
([0-9]{3}.[0-9]{12}) (-[0-9]{2}.[0-9]{13})
with
[\2,\1]
with the wildcard option set.
http://www.gmayor.com/replace_using_wildcards.htm

[macropod]

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

[stephanberger4]

Both right ! Thank you for the answers ! Working great !