Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Extract text (Count of text) from dwg to excel

nck5678
Enthusiast

Extract text (Count of text) from dwg to excel

nck5678
Enthusiast
Enthusiast

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).

0 Me gusta
Responder
Soluciones aceptadas (3)
612 Vistas
5 Respuestas
Respuestas (5)

VincentSheehan
Advisor
Advisor

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.

Eattext-4.png

Eattext-5.png

Vincent Sheehan

Sr. Civil Designer
Poly In 3D Blog

0 Me gusta

pendean
Community Legend
Community Legend
Solución aceptada

@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...

0 Me gusta

nck5678
Enthusiast
Enthusiast

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.

 

0 Me gusta

nck5678
Enthusiast
Enthusiast
Solución aceptada

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? 

0 Me gusta

pendean
Community Legend
Community Legend
Solución aceptada

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

Enjoy!


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