Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2021, 06:31 AM
mswmacroman mswmacroman is offline Advanced or refined search and find (Wildcards) Windows 7 64bit Advanced or refined search and find (Wildcards) Office 2013
Novice
Advanced or refined search and find (Wildcards)
 
Join Date: Apr 2014
Location: Czech Republic
Posts: 21
mswmacroman is on a distinguished road
Default Advanced or refined search and find (Wildcards)

How can you search for all instances of a number format in a 2013 MS Word document such as 32.3426833, -90.1381667 where the numbers differ and they may or may not be prefaced with a negative sign? These are decimal degree coordinates of the earth. I need to locate all such in three separate word documents that are in excess of 200 pages.
Reply With Quote
  #2  
Old 08-16-2021, 07:43 AM
Charles Kenyon Charles Kenyon is offline Advanced or refined search and find (Wildcards) Windows 10 Advanced or refined search and find (Wildcards) Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Will the numbers always have seven digits following the decimal point? Is the pattern always ##.#######?

Wildcards work on the Find function to give you multiple options. The following pattern should get you to these numbers although it may pick up others and should not be used for replace because it may not pick up the entire number.
Code:
[0-9]{1,3}.[0-9]{7}
Someone else (like Graham), better versed in use of wildcards, may come along and give you the exact pattern you need. This is a useful tool to know.

Last edited by Charles Kenyon; 08-16-2021 at 11:39 AM. Reason: added wildcard codes
Reply With Quote
  #3  
Old 08-16-2021, 11:44 AM
Robert2 Robert2 is offline Advanced or refined search and find (Wildcards) Windows 10 Advanced or refined search and find (Wildcards) Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 165
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

As explained at Convert Coordinates - Calculate a position in a variety of formats, there is a wide variety of latitude/longitude and position formats. Which format was used in your document? Was it consistent?
Reply With Quote
  #4  
Old 08-16-2021, 01:37 PM
mswmacroman mswmacroman is offline Advanced or refined search and find (Wildcards) Windows 7 64bit Advanced or refined search and find (Wildcards) Office 2013
Novice
Advanced or refined search and find (Wildcards)
 
Join Date: Apr 2014
Location: Czech Republic
Posts: 21
mswmacroman is on a distinguished road
Default

Thanks, Charles and Robert, for your help. This search [0-9]{1,3}.[0-9]{7} works very well for what I need.
Reply With Quote
Reply

Tags
find



Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced or refined search and find (Wildcards) Using wildcards with SEARCH 14spar15 Excel 7 10-14-2020 08:43 AM
Advanced Find and Replace with Wildcards help needed Amapola188 Word 3 07-23-2019 10:54 PM
Advanced or refined search and find (Wildcards) Need Search and Replace Help w Wildcards Oberstfunster Word 2 12-06-2018 09:28 AM
Advanced or refined search and find (Wildcards) Search with wildcards imag Word 1 11-05-2014 11:42 PM
Advanced find - default search all AdamSitra Word 0 08-03-2011 04:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft