Extract text (Count of text) from dwg to excel

[nck5678]

Hello All,

I need assistance and would appreciate some help.

I have a task, wherein I need to extract data from AutoCAD drawing in to excel.

The idea is to count the number of instances of Text (Single line or ML) within AutoCAD drawings, and write it against corresponding table value in excel.

For E.g., If a have drawing layout with multiple electric panels (A1, B2, C3, etc.) where A1 is name of one panel, in the excel file I wish to have a count of total A1 in the drawing. (I don't want all text's to be exported but only the one's I wish to count to be counted).

[VincentSheehan]

Try EATTEXT then step through the wizard.

1. Create a new data extraction.
2. Save the file.
3. Select the text.
4. Extract from objects.
5. Uncheck everything except but Value and Contents.
6. Set column option.
7. Export to Excel.

It seems the Value only reads Text objects. The Contents reads MText objects.

[pendean · Accepted solution]

---

@nck5678 wrote:

...The idea is to count the number of instances of Text (Single line or ML) within AutoCAD drawings, and write it against corresponding table value in excel....

---

This LISP will get you started on your journey

https://lee-mac.com/tcount.html 

Then... https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/Exporting-table-to.... 

[nck5678]

Hello, Thank you for reply.

However, I tired this initially but the issue is that this extracts the entire text. If there's a series of string and I wish to count the text from it, it gets difficult.

[nck5678 · Accepted solution]

Hello @pendean , Thank you for quick reply.

This LISP file does sounds good, but I can see there's a copyright to this LISP routine. Is it permissible to use these routines for office work? 

[pendean · Accepted solution]

All the LISP there is free to use: the copyright is for 'stealing' the code and passing it off as your own 🙂

Enjoy!

There is an attribute version of the LISP too if you need that, plus so many other cool tools.