If you are absolutely sure that all of your part numbers obey the pattern as in your examples -- one or more uppercase letters, a hyphen, one or more digits -- and no other "regular" text has this pattern, then GREP indeed is the answer.
Thanks for the the quick answer. But what if I have some items that I have already changed the item numbers with FC in front of the item numbers. How can I filter out those items from my search that already have FC and only search for the items without the FC.
One way would be to just run it and then *remove* any double FC's -- but GREP can do even more! One of its many functions is to scan ahead for the presence or absence of certain text, and only act when it is (or it is not) there. This is called "lookbehind" (before the text you want to match) and "lookahead" (after the text you want to match).
In this case, you want to find a phrase starting with capitals, but NOT the exact string "FC". That's a job for Negative Lookahead -- Only Match If Not.
Try this: search for
... the Replace With stays the same.
I would just make a fresh copy of the old catalog and run the GREP sequence. Just dump the one you have partially fixed. That's what I would do.
Thank you very much for your suggestions! Your code as saved me hours of time. I really need to learn more about GREP.
Now I have QR Code with copy another it which are grouped together on different layers and I need to move it on its own layer where I can turn the layer off on FC catalog. I have posted this question separately, hope to get an answer for it.