firsrate_caduser Posted January 23, 2009 Posted January 23, 2009 Hello everyone in here!! I have many many drawings with simple text you "DT" and then I was assign to extract that information to an excel file. I have a lisp to do that but only works on blocks with attributes. Now maybe someo of you guys know a way to do that. thanks for all you help!! Quote
ReMark Posted January 23, 2009 Posted January 23, 2009 Are you looking for a lisp routine that will extract ALL text from a drawing no matter how it was created or whether or not it is part of an attribute? Quote
CarlB Posted January 23, 2009 Posted January 23, 2009 You could use the "find" command, replace a string with same string; number of instances will be reported. What do you need to extract besides the number of occurrences? Quote
ReMark Posted January 23, 2009 Posted January 23, 2009 There's this lisp routine at cadalyst magazine: "EXT.LSP extracts selected lines of text and copies them to an ASCII text file for use in other applications." Is that what you're looking for? Quote
firsrate_caduser Posted January 23, 2009 Author Posted January 23, 2009 Hi guys thanks for you promt reply!! well I have a lisp to extract text, but the problem is that it only extract the information in to .txt file format, and all the information is scater all over the file which then I have to edit to format it the way I want. see, here is what a want to do: LINE1--->ATT1 LINE2--->ATT2 and then to be extracted to an excel file: ROW A--->LINE1 ROW B -->LINE2 all sequentiely to be A1, A2 A3...ETC same thing for B1, B2, B3...ETC. I hope this is clear for you guys. ps...some drawings have a lot of text. also the text is in groups of two like I explain it. thanks for all you help!! Quote
ReMark Posted January 23, 2009 Posted January 23, 2009 Someone calling themselves therealjd posted this at the AutoDesk Discussion forums when a similar question was posted: "You can use the data extraction wizard to setup a template and extract text or mtext information from a drawing. All of it can be exported to an Excel file. Type DATAEXTRACTION to start." I think this about does it for me. I'm on to other questions. Good luck. Quote
firsrate_caduser Posted January 23, 2009 Author Posted January 23, 2009 Thank you ReMark!! I will try that and hoping it would help me... {)) Quote
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.