Data Harvesting

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

  1. ShiftZZ

    ShiftZZ Funster Life Member

    Joined:
    Feb 19, 2008
    Messages:
    19,821
    Likes Received:
    35,893
    Location:
    Leicestershire
    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,246
    Likes Received:
    34,478
    Location:
    Acklam, Teesside, originally Glossop
    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,258
    Likes Received:
    1,612
    Location:
    Ecclefechan
    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:
    643
    Likes Received:
    214
    Location:
    Derbyshire
    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:
    8,510
    Likes Received:
    12,721
    Location:
    Norfolk
    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 Read Only Funster

    Joined:
    Nov 10, 2008
    Messages:
    261
    Likes Received:
    1
    Location:
    Anywhere in Europe, so fa
    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 Read Only Funster

    Joined:
    Apr 13, 2009
    Messages:
    48
    Likes Received:
    0
    Location:
    Europe-wide
Loading...
Similar Threads
  1. matamoros
    Replies:
    21
    Views:
    406
  2. ShiftZZ
    Replies:
    3
    Views:
    232
  3. Hils and Glenns
    Replies:
    1
    Views:
    278

Share This Page