![]() |
|
|
|
#1
|
|||
|
|||
|
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. |
|
#2
|
||||
|
||||
|
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] |
|
#3
|
|||
|
|||
|
Quote:
Interesting approach. Thanks for the idea. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Help with WildCards Find & Replace either or nothing...
|
Cendrinne | Word VBA | 9 | 11-14-2020 08:25 AM |
Find and replace text with wildcards
|
arunchandar9 | Word VBA | 15 | 06-30-2019 01:06 AM |
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 |