Data Harvesting

Discussion in 'Computers' started by ShiftZZ, Oct 26, 2009.

  1. ShiftZZ

    ShiftZZ Funster Life Member

    Joined:
    Feb 19, 2008
    Messages:
    20,303
    Location:
    Leicestershire
    Ratings:
    +47,203
    I am looking to extract data from word documents etc.
    I am looking to extract email addresses, phone numbers and addresses, is there some free solftware that can do this.

    Its not for spamming, just to populate a database., Save a lot of typing..

    ShiftZZ
     
  2. GJH

    GJH Funster Life Member

    Joined:
    Aug 20, 2007
    Messages:
    27,480
    Location:
    Acklam, Teesside, originally Glossop
    Ratings:
    +38,850
    I can't think of any software, either free or paid for, which would extract information like that from totally unstructured WP documents.

    If the details are held within a table in the WP documents you could possibly copy it and paste it into a spreadsheet and then manipulate that so you end up with a database.

    Otherwise copy & paste is probably all that you could use.

    Graham
     
  3. keith

    keith Funster

    Joined:
    Aug 25, 2007
    Messages:
    3,403
    Location:
    Ecclefechan
    Ratings:
    +1,886
    I have found that it is sometimes possible to do it by copy & paste into an Excel doc.
    It will go into 1 column, then under data go to 'text to columns' see if will sort it into multiple columns.
    It has worked for me in the past.
     
  4. algill

    algill Funster

    Joined:
    Dec 12, 2007
    Messages:
    649
    Location:
    Derbyshire
    Ratings:
    +217
    You can import files into Access. Create a new database. Select File, Get external Data, Import. I have some instructions for this - will try attaching.

    Works okay when importing from Excel - not tried doing it from Word. I would think you need the data in a table first in Word.

    Gill
     
  5. Larrynwin

    Larrynwin Funster

    Joined:
    Feb 22, 2008
    Messages:
    9,929
    Location:
    Norfolk
    Ratings:
    +23,553
    A couple of years ago I had a disc from Serif that enabled scanning and conversion to live word documents. I believe it was when I was running XP.
    I will look for the disc tomorrow and post a reply if I can find it.
    Larry
     
  6. ArenqueRojo

    ArenqueRojo

    Joined:
    Nov 10, 2008
    Messages:
    261
    Location:
    Anywhere in Europe, so fa
    Ratings:
    +3
    Is there any structure to the Word document?
    If there is, I can probably help by writing a bit of code to do it.
    If you want to PM me with a bit of the document, I'll have a look for you.
    Patrick
     
  7. andycotterell

    andycotterell

    Joined:
    Apr 13, 2009
    Messages:
    48
    Location:
    Europe-wide
    Ratings:
    +1

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice