vds002 Posted February 20, 2009 Share Posted February 20, 2009 I have around 40 Drawings and each drawing has round 30 instruments. Each instrument has a TAG(text name) (eg TI 1001, PT 0403). However our CAD drafters have put the tags as text and not as attributes. Now the client wants us to change the format in with the tags are (eg 1210TI 101A, 1329PT 205). Is it possible to generate a EXCELL spreadsheet from AUTOCAD---change the tags to new format ---import it back into AUTOCAD so that the names can automatically be changed. I would appreciate if anyone can give some inputs. Quote Link to comment Share on other sites More sharing options...
vds002 Posted February 20, 2009 Author Share Posted February 20, 2009 I have around 40 Drawings and each drawing has round 30 instruments. Each instrument has a TAG(text name) (eg TI 1001, PT 0403). However our CAD drafters have put the tags as text and not as attributes. Now the client wants us to change the format in with the tags are (eg 1210TI 101A, 1329PT 205). Is it possible to generate a EXCELL spreadsheet from AUTOCAD---change the tags to new format ---import it back into AUTOCAD so that the names can automatically be changed. I would appreciate if anyone can give some inputs. Quote Link to comment Share on other sites More sharing options...
JohnM Posted February 20, 2009 Share Posted February 20, 2009 You need to be more detailed and precise in your question. The before tag and the after tag examples mean nothing to anybody but you. Please supply an example of one tag with a certain number then show what the same tag should look like when changed. Quote Link to comment Share on other sites More sharing options...
CarlB Posted February 21, 2009 Share Posted February 21, 2009 It would help to know the pattern of the "tag" changes to create a routine; however a routine could be created that reads a file, and just replaces (all instances of) one text item with another. File could be in a format like: TI 1001, PT 0403;1210TI 101A, 1329PT 205 Odd Tagg 2;Renamed Odd tag 2 etc... Quote Link to comment Share on other sites More sharing options...
Cad64 Posted February 21, 2009 Share Posted February 21, 2009 I have merged your two threads into this one. Please don't cross post. This just makes it difficult to follow your progress. Quote Link to comment Share on other sites More sharing options...
dbroada Posted February 21, 2009 Share Posted February 21, 2009 as above, a bit more detail would go a long way. There are several ways of doing it and the best will depending on how many tags you have to change and how the new data is presented. Do you already have an excel sheet with the before & after tags or do you want to get all the tags into the spreadsheet and manipulate them all there. Is the format clearly defined? Can you say the new tag will always be (for example) the 3rd to 6th letters followed by a space and finished with the first 2 or is there more to it than that. When I last had to do this is was a simple matter of rearranging the letters that were already there so I wrote a LISP routine that allowed me to pick the text and the routine replaced it with the new arrangement. I think I had a few routines as there were some 3 and 4 lettered tags too but it was relatively quick to go around the drawing clicking on text. I don't have that routine anymore though as we don't do our instrument loops that way these days. Obviously if the conversion involves more than simple manipulation then this approach is not going to help you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.