SteveBMe
2008-05-06, 06:45 PM
Hello all.
While I've been using AutoCAD for a few years, I've never had the need to do the following before.
I want to extract text from a multi-text, or a D-text string, and have it export to an excel file-- as text.
Thus far, each time I go to do this by selecting the lines of text, and ctrl+c, it essentially gives me an image (Excel appears to treat it as an image) file that I then must enter the data manually in to Excel, by reading the "image" file myself.
I've posted on the MSDN newsgroups, and found that it won't work from that end, so I looked around the help file, and couldn't find anything that would explain how I could do this.
I did a search here and found where someone back in early 2006 wanted to pull the layer info out and import that to Excel as a text file. I was not however able to easily identify anything that I wanted to do.
http://forums.augi.com/showthread.php?t=31599&highlight=export+text%2C+dwg%2C+excel%2C+text
my general search parameters returned the following.
http://forums.augi.com/search.php?searchid=223506
Search: Key Word(s): export, text,, dwg,, excel,, text
I tried making it a complete sentence, but it kept telling me I didn't provide enough words, and was under the minimum required 3 words so I wound up removing words like do, and to.
We're using Map3d 2007, and Office 2007 here.
Thank you for your responses.
I've attached a word doc. with a screen shot of what I have. The image is green (something to let me know I processed the data already.) The text to the left of the green dwg data is my entries of the information I want to import as text to excel.
While I've been using AutoCAD for a few years, I've never had the need to do the following before.
I want to extract text from a multi-text, or a D-text string, and have it export to an excel file-- as text.
Thus far, each time I go to do this by selecting the lines of text, and ctrl+c, it essentially gives me an image (Excel appears to treat it as an image) file that I then must enter the data manually in to Excel, by reading the "image" file myself.
I've posted on the MSDN newsgroups, and found that it won't work from that end, so I looked around the help file, and couldn't find anything that would explain how I could do this.
I did a search here and found where someone back in early 2006 wanted to pull the layer info out and import that to Excel as a text file. I was not however able to easily identify anything that I wanted to do.
http://forums.augi.com/showthread.php?t=31599&highlight=export+text%2C+dwg%2C+excel%2C+text
my general search parameters returned the following.
http://forums.augi.com/search.php?searchid=223506
Search: Key Word(s): export, text,, dwg,, excel,, text
I tried making it a complete sentence, but it kept telling me I didn't provide enough words, and was under the minimum required 3 words so I wound up removing words like do, and to.
We're using Map3d 2007, and Office 2007 here.
Thank you for your responses.
I've attached a word doc. with a screen shot of what I have. The image is green (something to let me know I processed the data already.) The text to the left of the green dwg data is my entries of the information I want to import as text to excel.