Multisearch

[teadan]

Hello, I'm pretty new in Lisp coding. I'm trying to do the following:
I have a cable list in Excel format, I want to do a search and highlight (select) the results of each of the cables found in the .dwg drawing. For this, I will change the color of the cable name, so when the script finishes, I have both the cables found in color, and the ones that it didn't find, in black color in the .dwg, for a consistency check.
The script should move from cable to cable from the list and make a find & colour it (exact match only). Also, I have a multi-layout cad file for the look up.
Example: Cable code: IA-ABC-126, if found -> change it to red, otherwise, it will remain black.
I'm really messed up with the language, so when I try to mix some codes it ends up not working.
Any help for these would be really appreciated.

Thanks!

 

[teadan]

I have made an approach, using two functions, the first one BFindV2-0.lsp from Lee Mac, (batch find&replace) to add an string to the ones found (IA-ABC-126 -> IA-ABC-126 OK). And then the other one, to select all the "OK" added and change the color of the cable.
So the task is made. I have the .dwg file with the coloured cables found and black not found from the list.
The problem is that I also need the other way around. I can't see which cables are not found in the .dwg file from the Excel list. Any ideas? To add a list of "Not found" in the "BFindReport"?