RE: extracting embedded or Ole Object data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

ok, so seeking to extract "graphical" data will not work.
I'll look at ACad to see how to export the text in the files to a text file,
and then I know how to import txt files to excel. Or at least I once knew how
to....
Thanks.



"Joel" wrote:

I was looking at the drawings with a viewer (not autcad). These images a
graphic images and you can't extract text from these files.

You need to work with the CAD package that created the drawings and perform
and export to get text data. Once your data strings are in text they can be
automatically imported into excel.

There are usually text formats that the CAD vendors use to transfer files
from one CAD package to another that aren't graphic. these berst bet is to
use one of these formkats and see if the data your are looking for are in
these files.

I can extracrt any data from a text file using macros. I cna't extract this
data from the graphic files on the website.

"SteveDB1" wrote:

Good morning Joel.
I posted once, but got an error message saying there was too much traffic to
post, so I'll try again. If it ends up showing up as a double post, just
ignore one of these.
Please bear with me while I try to remember what I'd said before.

The general case is that we make small regional maps that show assessor
parcel numbers- APN's, and their respective acreages. We also make up Excel
worksheets that show those APN's, and their acreages. From time to time we
update those maps, and because of the map update we need to update our excel
records that keep track of the owners of the respective APN's. To facilitate
my updating, I select an "image" of the map, or highlight the APN data, and
select it. It then pastes that data into my worksheet as an object
(=EMBED("AutoCAD.Drawing.17","")). That is the equation in the formula bar.
The name box just calls it an "object."

For source data to start working from, please go to our website-- address
below. You'll need the dwf viewer from AutoDesk. We have a link at the top of
that webpage. Select any map in the list, and then "copy an image" of the APN
list.

http://water.nv.gov/Adjudications/Mapping/Truckee/oddclaims.cfm
Sample data below.

APN Acreage
036-581-03 0.11
036-581-04 0.13
036-581-05 0.09



As I think about your statement regarding the importation of a text file, I
remember that I've done that in the past. I did in fact think aboutthat, and
did not consider it the same as what I'd done before, because this shows up
as an image, instead of an editable text (*.txt) file.

"Joel" wrote:

Of course of course. You really don't have an Oleobject, you have a text
file that you want to extract certain strings. I have done this a lot. It
could get complicated depending on the file. If you post some of the text
file and specify what string you need extracted I wil get yyou started, maybe
even get the whole thing done depending on how complex the task is.

"SteveDB1" wrote:

Hi all.
I have need to pull text data from an embedded, or an OLE object I pull
from-- in this case-- an AutoCAD DWG file.
Thus far I've been going through the embedded element one line-item at a
time, and have finally gotten tired of it.
Is there a way to pull the information off of an embedded object within
excel?
I'm using Office2007.
Thank you.

.

Relevant Pages

  • Re: MuPad 3.0 extraction of individual eigenvectors
    ... Christopher Creutzig wrote: ... >> that case, the aforementioned use of op, map and indexing is still ... > way of asking MuPAD “if I wanted to extract this, ...
    (sci.math.symbolic)
  • RE: extracting embedded or Ole Object data
    ... I was looking at the drawings with a viewer. ... graphic images and you can't extract text from these files. ... We also make up Excel ... update those maps, and because of the map update we need to update our excel ...
    (microsoft.public.excel.programming)
  • Re: Parsing File
    ... Like you, I'm not sure what the OP is trying to extract from the file, so ... The map() should really be a "for" here (you're ... pattern extraction by pattern substitution is in general not recommended. ... is a standard situation: Watch lines passing by and extract matches ...
    (comp.lang.perl.misc)
  • Re: sorting in order of values
    ... extract the pairs), sort them, and traverse the sorted data instead ... of the original Map. ... I was about to try this out but i realised that this wouldnt ... Because i need to populate the values from a Map. ...
    (comp.lang.java.programmer)
  • Re: Selecting every 4th row
    ... Use the following formula to extract every 4th row: ... H$2 to the first cell in which you enter this formula. ... does pull every 4th row and puts it in a new column to not have 3 blank ... Using Excel 2003. ...
    (microsoft.public.excel.misc)