Display full version of the post: Can This Be Done..?

lifeis
01.12.2010, 15:45
Hey Guys,This is my first post. I work as an Electrical Engineer and frequently use CAD and write Software.However today I have the tedious task of looking through thousands of names in an Access Database table and looking up those names using the FIND command on an AutoCAD 2010 drawing.I know that there has to be an easier way to do this than going through reading the name in Access and typing it in the 'Find what:' box in CAD.Could I write a LISP or some form of script to read a list of the words, and do the search for me. All I need to confirm is that each word in the Access database exists on the drawing, so I could confirm if this is the case by reading the lisp Log etc to check if the Script found each word and then identify what it did not find.Any help would be great guys.Thanks for your help.-Craig

lifeis
02.12.2010, 10:14
anyone got any ideas?

lifeis
02.12.2010, 11:37

Okay guys, I found a way to do what I need. A lisp routine (or script, I don't know the AutoCAD terminology) called 'SrxTEXT' which can then load a CSV file which contains a list of text to search for. This is perfect for me. However some of the text I need to find is in like 'tags' (little blocks that you have to click on then a dialog pops up and you type in the values, next to a little description eg: ***EDIT:- I think these are called 'Block References'***FIRST NAME- <type value here>SECOND NAME- <type value here>again I don't know the correct name for these tag blocks, but I hope you understand what I mean).So I didnt think this would be a problem, however the SrxTEXT script does not search in these Tag Blocks, only searched for text such as MLINE text etc.How can I fix this, I don't mind altering the drawing.I tried exploding the whole drawing, which would have worked, although all the values I want to search dissappeared, and only the line descriptions remained. Eg. the, 'FIRST NAME' bit stayed, and the <type value here> bit dissapeared.Thanks for any help guys.
lifeis2010-12-02 12:07:29