I have inherited the CAD manager position for a large project that has been under way for some time now. Certain important CAD standards have been ignored and it is my job to fix this condition. In particular, our sheet standards require that the title block and the issue date be blocks with well defined attribute tags to facilitate retrieval. We have programs in VBA and Object DBX that read this title block and issue information efficiently and quickly and generate management reports.
Most of the drawings have incorrectly inserted the title block information as simple text. I propose to retrieve this text and its insertion coordinates with a VBA filter and then sort by the Y value and then the X value. I will then erase the text, insert the correct block and set the attribute text from the stored values. This should work with most of the sheets. I am confident I have the skill to do this; I have done it before successfully.
Some of the text was inserted as a non standard block. That can be exploded without too much fuss.
My problem is that the issue dates have been inserted as loose attributes, not associated with any block. If you examine the issue date info in the attached file, you will find a very strange condition. The attribute has no value, and the displayed text on the drawing is in fact the tag! Even if I edit the attribute to have an explicit value, it still displays the tag and not the value.
I have tried exploding the attribute. I have tried express tools/attribute to text. After consulting with other experienced CAD managers, still no solution. There are several thousand drawings involved and any procedure will have to be automated through VBA. (I don't really know Lisp)
Attached is a bound sheet with the essential border, title and issue date information. The client and data have been removed to protect the innocent.
If you like puzzles, you'll like this!