Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Table terror (2000 sp-3/ 98SE)

    I've been blessed with the task of consolidating several dozen substantial tables of data into a single document with consistent formatting (probably a CHM/HTML collection). These tables come from many sources (HTML, PDF, Word doc, spreadsheet...) and have nothing in common except that they are all tables. <img src=/S/sad.gif border=0 alt=sad width=15 height=15> So far, I've found the only "universal" collation method I can use is:

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Table terror (2000 sp-3/ 98SE)

    1) Why do you need to copy/paste a column at a time? In many cases, Excel will automatically paste a table correctly, and there is also the Text to Columns Wizard.

    2) Why do you need Word as an intermediate step? Excel can export to tab-delimited text too (File | Save As...)

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table terror (2000 sp-3/ 98SE)

    So far I've found:

    1) Several of the tables I've dealt with so far e.g. from a PDF, paste into XL as a single column (1 table row per cell). XL places a space character between each original cell entry in a table row. Text to columns is difficult in such cases, because the delimiter is a space, and spaces may legitimately belong within cell text.

    2) I could save to a file, then reopen in the HTML utility and convert. It's probably fewer operations to use Word as an intermediary, pasting the XL range, convert table to tab-delimited text, copy - paste to HTML conversion utility. I think it would be better for the "production line" solution I hope to achieve.

    Like I said, there's little in common amongst the original tables.

    Alan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Table terror (2000 sp-3/ 98SE)

    Thanks for the explanation. With the diversity in sources, there is probably no easy workaround for pasting column by column.

    You could create VBA code to copy the selection in Excel to the clipboard, paste it into a Word document, convert to tab-delimited text and copy the result to the clipboard again, ready to be pasted into your HTML utility.

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table terror (2000 sp-3/ 98SE)

    Thanks Hans. That's about the only level of automation I could think of too, using these tools and methods. I was kinda hoping for one of those elusive magic programs that says "Ah, I see what you're trying to do now. Go off and have a beer or six and leave it all to me." <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Alan

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Table terror (2000 sp-3/ 98SE)

    Just couldn't resist, Alan

    >I was kinda hoping for one of those elusive magic programs

    and whom do you think it would be most likely to find one of those elusive magic programs?

    Not to say that others don't find great things but that guy Alan Miller (any relation?) usually finds some pretty good ones! HUGE <img src=/S/grin.gif border=0 alt=grin width=15 height=15>


    Fred

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table terror (2000 sp-3/ 98SE)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> What's the expression? Make a rod for your own back?
    Although now, according to bigaldoc's post, it looks like I'm out of a job. However, all may not be lost.
    Does the new Bond remind you of anybody we know? I may have to get him on the job.

    Alan

Posting Permissions

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