Results 1 to 8 of 8
  1. #1
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Saving name/address from IE into Word table cell

    This could have gone either into Internet Explorer or Word, I suppose, but this may be right?

    In Internet Explorer, a website is giving me a name-and-address, roughly in the standard five- or six-line format, no doubt in an ASP page and in a table, in several "cells".

    I want to grab it, and place the resulting five or six lines into a Word table cell, later to be used to print address labels.

    This is repeated almost interminably, or until I get bored, whichever comes first!

    I've tried doing cut and paste, but far too much baggage comes with it in the way of table cell borders, and multiple cells.
    I've tried saving as HTML, but that gives hectares of useless data which has to be removed.
    I've tried printing to a Generic/Text only printer, but this requires a LOT of typing to save it, and a lot of editing of the PRN file to get into a usable format.

    Does anyone know of a minimum effort method of just getting the text of the name and address? Possibly using a program that could grab the data in a box drawn round the name and address fields?

    Whatever happened to those wonderful green screens on mainframes that did 80 characters across by 24 down, and you could do a screen scrape on?? <img src=/S/sad.gif border=0 alt=sad width=15 height=15>
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  2. #2
    5 Star Lounger
    Join Date
    May 2002
    Location
    43.8N 81.0W, Ontario
    Posts
    815
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving name/address from IE into Word table cell

    Hi John

    I'm not sure if this is what you are looking for, but it might be worth a try.......
    Snagit has a Text Capture Tool that will capture text from your screen and output it in editable format.

    Have a Great day!!!
    Ken
    <IMG SRC=http://www.wopr.com/w3tuserpics/KenK_sig.gif>

  3. #3
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Saving name/address from IE into Word table cell

    After copying, try "Edit, Paste Special" and then "unformatted".

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Saving name/address from IE into Word table cell

    <P ID="edit" class=small>(Edited by jscher2000 on 18-Jul-03 16:21. Actually, you only want the result in a single cell, so ignore this.)</P>If the HTML table consists of only one column, you can do this:

    1. <LI>Select the rows of the table that you want to copy; press Ctrl+V
      <LI>In Word, set up a table with at least one column and at least as many rows
      <LI>Select enough cells in the first column to match the number of rows you copied
      <LI>Edit>Paste Special>Unformatted
    I created a keystroke macro for Edit>Paste Special>Unformatted because I do it so often:

    Sub PasteSpecialUnformatted()
    Selection.PasteSpecial DataType:=wdPasteText, Placement:=wdInLine
    End Sub

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving name/address from IE into Word table ce

    <P ID="edit" class=small>(Edited by Phil Rabichow on 18-Jul-03 17:21. to add the 4th suggestion)</P>Hi John:
    In addition to what's been mentioned, there are several options.
    1. Netscape (or Mozilla) copies only the text. In some cases a disadvantage, but here....
    2. If you copy & even paste it as formatted text (Ctrl+V), you can still select everything, press Ctrl+Spacebar & Ctrl+Q to remove excess formatting. You could also select the table, right click, & choose Convert to text (a Word solution).
    3. Finally, there are clipboard extenders (since you posted here in software wants <img src=/S/grin.gif border=0 alt=grin width=15 height=15>) that will paste the text format. Smartboard is one.
    4. And lastly (which comes after finally <img src=/S/grin.gif border=0 alt=grin width=15 height=15>), you can show the Tables & Borders toolbar, which has a pencil & eraser tool that you can use to modify your table, since that's what you want. Klaus had an excellent description of the technique in the Word forum, but alas, I'm sure it's temporarilly culled. Still, it shouldn't be too difficult to do.

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Saving name/address from IE into Word table cell

    At work I use a program called Monarch from Datawatch that has the ability to extract information from text files based on templates. The newest version supports extracting data from HTML files. (I've been using it for about four years now, to translate static text reports to dynamic data, and the program just keeps on getting better.) Using a flexible template, the program can search through the code, find the specifics you are looking for, and drop them into a table automagically. Unfortunately it is not exactly a 'minimum' amount of effort to set up, and would require saving the web pages as HTML text, but if you need to do it often enough the effort could pay off handsomely in the long run.

    Another possible program to use is NoteTab. NoteTab is primarily a text editor that makes for a superb alternative to the standard Windows Notepad, but it comes with some pretty useful HTML coding tools -- including the ability to take a HTML text file and strip all HTML code and/or tags out (handy toolbar icons for this, too). Use this program to 'View source' the page, strip the code, and you are left with a plain text file that should make finding and copying the desired information much easier. The price for the 'Lite' version is perfect too: <img src=/S/free.gif border=0 alt=free width=30 height=15>, with no nags or malware whatsoever. I've attached a sample of what NoteTab can accomplish, using this reply in its native form and stripped form for comparison.
    Attached Files Attached Files

  7. #7
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Saving name/address from IE into Word table cell

    Thanks, folks, I'll try all these suggestions on Monday, and report back!
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  8. #8
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Saving name/address from IE into Word table cell

    Ken: thanks for the suggestion, but SnagIt is $40!

    Dave/Jefferson/Phil: the Copy/Edit/Paste Special/Unformatted method appears to require minimum effort, so I award you the "sort JG out again" prize of the month! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>

    David: NoteTab Lite seems an interesting program, but seems to have suffered from someone's Bright Ideas!
    Would you really want a replacement for NOTEPAD to do:
    Temperature conversions?
    Calculate your ideal weight from the height you supplied?
    Mortgage Rates and Future Value of Deposits?

    There seems to be a lot of good stuff as well as the stuff I've mocked, and I'll look at it in more detail when I've done the above task!
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •