Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-08-2022, 11:34 PM
wrdy wrdy is offline Can I use wildcards to find missing words? Windows XP Can I use wildcards to find missing words? Office 2007
Advanced Beginner
Can I use wildcards to find missing words?
 
Join Date: Jan 2014
Posts: 31
wrdy is on a distinguished road
Default Can I use wildcards to find missing words?

A Word document was changed from this:



John Smith johnny password
Sally Jones sallyj 12345678
Paul Hunter phunter 11111111
David Green greenie pppppppp
Peter Underwood peter pete1995


to this:



First name: John. Last name: Smith. Username: johnny. Password: password.
First name: Sally. Last name: Jones. Username: sallyj. Password: 12345678.
First name: Paul. Last name: Hunter. Username: phunter. Password: 11111111.
First name: David. Last name: Green.greenie. Password: pppppppp.
First name: Peter. Last name: Underwood. Username: peter. Password: pete1995.





Now, as part of QC, I want to check that that "First name", "Last name", "Username" and "Password" are not missing from any lines. For example, "Username" is missing from line 4.


Can I use a wildcard search to do this or do I need to use a macro?


I don't mind having to search each term separately and I don't mind manually adding the term when found to be missing.
Reply With Quote
  #2  
Old 04-09-2022, 07:28 AM
macropod's Avatar
macropod macropod is online now Can I use wildcards to find missing words? Windows 10 Can I use wildcards to find missing words? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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

You could first apply a red font to the whole document, then use a wildcard Find/Replace like:
Find = First name: [!.]@. Last name: [!.]@. Username: [!.]@. Password: [!.]@.[^1^13]
Replace = ^&
with the replacement font colour set to automatic.

Any unmatched lines will remain red-coloured.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-11-2022, 09:07 PM
wrdy wrdy is offline Can I use wildcards to find missing words? Windows XP Can I use wildcards to find missing words? Office 2007
Advanced Beginner
Can I use wildcards to find missing words?
 
Join Date: Jan 2014
Posts: 31
wrdy is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You could first apply a red font to the whole document, then use a wildcard Find/Replace like:
Find = First name: [!.]@. Last name: [!.]@. Username: [!.]@. Password: [!.]@.[^1^13]
Replace = ^&
with the replacement font colour set to automatic.

Any unmatched lines will remain red-coloured.

Interesting approach. Thanks for the idea.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I use wildcards to find missing words? Help with WildCards Find & Replace either or nothing... Cendrinne Word VBA 9 11-14-2020 08:25 AM
Can I use wildcards to find missing words? Find and replace text with wildcards arunchandar9 Word VBA 15 06-30-2019 01:06 AM
Can I use wildcards to find missing words? Wildcards: searching for multiple words / expressions close to each other ballpoint Word VBA 7 11-09-2017 03:30 PM
Using wildcards how do I Find and Add to, not replace Stargehzer Word 3 01-25-2016 09:14 PM
Find & Replace: Wildcards (except this pattern) tinfanide Word 6 01-26-2014 06:39 AM

Other Forums: Access Forums

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


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