Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2024, 10:30 PM
littlenellie littlenellie is offline Word wildcard search for paragraphs with single words Windows 10 Word wildcard search for paragraphs with single words Office 2019
Novice
Word wildcard search for paragraphs with single words
 
Join Date: Feb 2024
Posts: 4
littlenellie is on a distinguished road
Question Word wildcard search for paragraphs with single words

Hi,

Is there a way to do a wildcard search for paragraphs that only contain a single word?

A word that's any number of characters in length (not necessarily alphanumeric, could also include special characters) just as long as there's no spaces between them.



Anyone know?

Thanks!
Reply With Quote
  #2  
Old 02-17-2024, 11:33 PM
Robert2 Robert2 is offline Word wildcard search for paragraphs with single words Windows 10 Word wildcard search for paragraphs with single words Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 165
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

Click "Find in Main Document" after entering the following wildcard search:
[!^13]@
Reply With Quote
  #3  
Old 02-18-2024, 12:13 AM
littlenellie littlenellie is offline Word wildcard search for paragraphs with single words Windows 10 Word wildcard search for paragraphs with single words Office 2019
Novice
Word wildcard search for paragraphs with single words
 
Join Date: Feb 2024
Posts: 4
littlenellie is on a distinguished road
Default

Hi Robert, thanks for replying.

This didn't seem to work for me, though. When I ran it as "Find in Main Document" it hung/crashed Word, so I tried it as a 'Find Next' wildcard search and it found whole paragraphs (multiples words including spaces), with each subsequent 'Find Next' selecting the same text with one character fewer than before.

Most of the info I've found on wildcard syntax is a bit vague about how to include whitespace as part of the criteria, which I'm guessing is needed to identify whole words.
Reply With Quote
  #4  
Old 02-18-2024, 12:45 AM
Robert2 Robert2 is offline Word wildcard search for paragraphs with single words Windows 10 Word wildcard search for paragraphs with single words Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 165
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

It is working in Word 2019.
[!^13] is searching for anything that is not a paragraph end mark. That includes space characters.
Reply With Quote
  #5  
Old 02-18-2024, 02:35 PM
littlenellie littlenellie is offline Word wildcard search for paragraphs with single words Windows 10 Word wildcard search for paragraphs with single words Office 2019
Novice
Word wildcard search for paragraphs with single words
 
Join Date: Feb 2024
Posts: 4
littlenellie is on a distinguished road
Default

Yes, that's the problem. I only want paragraphs that contain ONE word, but because it's including spaces it's including multiple words.
Reply With Quote
  #6  
Old 02-18-2024, 06:08 PM
Guessed's Avatar
Guessed Guessed is offline Word wildcard search for paragraphs with single words Windows 10 Word wildcard search for paragraphs with single words Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

What if you find this
"^13[A-Za-z]{1,}^13"

or
"^13[A-Za-z0-9]{1,}^13"
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 02-20-2024, 03:32 PM
littlenellie littlenellie is offline Word wildcard search for paragraphs with single words Windows 10 Word wildcard search for paragraphs with single words Office 2019
Novice
Word wildcard search for paragraphs with single words
 
Join Date: Feb 2024
Posts: 4
littlenellie is on a distinguished road
Default

Thanks for reply Guessed.

That syntax only works where there are no special characters, so if the word is in quotes, for example, it doesn't get picked up.

What I need is a way to include special characters (but not spaces!) in this part of the syntax: "[A-Za-z0-9]". Or a way to exclude spaces, in the same way that this syntax excludes paragraph marks: "[!^13]"
Reply With Quote
  #8  
Old 02-20-2024, 04:19 PM
Guessed's Avatar
Guessed Guessed is offline Word wildcard search for paragraphs with single words Windows 10 Word wildcard search for paragraphs with single words Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

OK try searching for this with wildcards
^13[! ]@^13
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA wildcard search that only identifies results that do not follow delineated words rekent Word VBA 4 09-23-2021 10:55 AM
Word wildcard search for paragraphs with single words Word VBA wildcard search - odd results MikeForward Word VBA 3 02-21-2019 06:18 AM
Word wildcard search for paragraphs with single words Want to do single wildcard search for Z?Z or Z??Z MikeForward Word 9 02-19-2019 01:27 AM
How to find (highlight) two and more words in a list of 75k single words in Word 2010 Usora Word 8 05-29-2018 03:34 AM
Sumif to find a single word in a cell without using wildcard kiteman Excel 3 08-23-2017 10:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 PM.


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