- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
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).
¡Resuelto! Ir a solución.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Try EATTEXT then step through the wizard.
- Create a new data extraction.
- Save the file.
- Select the text.
- Extract from objects.
- Uncheck everything except but Value and Contents.
- Set column option.
- Export to Excel.
It seems the Value only reads Text objects. The Contents reads MText objects.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
@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
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
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.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
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.