![]() |
|
#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. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Cendrinne | Word VBA | 9 | 11-14-2020 08:25 AM |
![]() |
arunchandar9 | Word VBA | 15 | 06-30-2019 01:06 AM |
![]() |
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 |