Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multisearch

Status
Not open for further replies.
teadan

teadan

Electrical
Mar 9, 2018
2
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!
 
Replies continue below

Recommended for you

Sort by date Sort by votes
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"?
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top Bottom