If I were doing the project, I'd take a couple steps backwards, to the HTML file, which I assume is still online.<div><br></div><div>Although I haven't done it, if you Google the string: "html table to excel" you'll find pages full of tools, including an Excel macro which apparently will bring it in cleanly.<br>
<div><br></div><div>Otherwise (the method I've used in the past), you can view the source code in another window of your browser. Copy and paste that into a text editor (Notepad, NoteTab Pro, whatever) and do a search and replace for the cell separator coding and row ends/beginnings to convert them either to tabs or commas, and carriage returns, respectively.</div>
<div><br></div><div>Once you have a comma or tab delimited table, you should be able to work on it in Excel, which I suspect will be quicker and easier for editing.</div><div>Then bring the cleaned up file into Frame by exporting as a text format FM can deal with -- the comma or tab delimited file.</div>
<div><br></div><div>Art </div><div><br><div>Art Campbell <a href="mailto:art.campbell@gmail.com" target="_blank">art.campbell@gmail.com</a><br> "... In my opinion, there's nothing in this world beats a '52 Vincent and a redheaded girl." -- Richard Thompson<br>
No disclaimers apply.<br> DoD 358<br><br>I support <a href="http://www.TheGrotonLine.com" target="_blank">www.TheGrotonLine.com</a>, hyperlocal news for Groton MA.<br>
<br><br><div class="gmail_quote">On Tue, Mar 6, 2012 at 9:41 AM, Timothy DeWees <span dir="ltr"><<a href="mailto:tdewees@charter.net">tdewees@charter.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal">Hi all,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I’m working on a project where a large document was originally in a database (I don’t know what software) that was updated and posted online as some sort of html document. The database was then converted to a Word file which I subsequently converted to frame. The whole document rendered as a huge, unmanageable table. So I created a new frame template so we will have a workable document in the future. The main problem I’m having is copying text in table cells from the old document into the new. For example, I’m trying to copy two table columns of text into a new two column table. But when I do, the text from the 1<sup>st</sup> column will cause my two columns to merge into a single column and the text from the second column does not appear anywhere. If I copy text individual cell by cell, it works fine. But this is going to be a 1500 page document and that would take forever. <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Any suggestions on an approach I might take so that I can copy / paste multiple rows at one time? I’m sorry I haven’t provided much info on the original table, but I don’t understand it myself. The original table was created in the conversion process and I would have no idea how to duplicate it. Thanks in advance for any suggestions.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Tim DeWees<u></u><u></u></p></div></div><br>_______________________________________________<br>
<br>
<br>
You are currently subscribed to framers as <a href="mailto:art.campbell@gmail.com">art.campbell@gmail.com</a>.<br>
<br>
Send list messages to <a href="mailto:framers@lists.frameusers.com">framers@lists.frameusers.com</a>.<br>
<br>
To unsubscribe send a blank email to<br>
<a href="mailto:framers-unsubscribe@lists.frameusers.com">framers-unsubscribe@lists.frameusers.com</a><br>
or visit <a href="http://lists.frameusers.com/mailman/options/framers/art.campbell%40gmail.com" target="_blank">http://lists.frameusers.com/mailman/options/framers/art.campbell%40gmail.com</a><br>
<br>
Send administrative questions to <a href="mailto:listadmin@frameusers.com">listadmin@frameusers.com</a>. Visit<br>
<a href="http://www.frameusers.com/" target="_blank">http://www.frameusers.com/</a> for more resources and info.<br>
<br></blockquote></div><br></div></div></div>