<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi All,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks for the many great suggestions. I’m going to try out some things and see what works best. I will post back later what approach I found worked out best for me.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Tim<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Art Campbell [mailto:art.campbell@gmail.com] <br><b>Sent:</b> Thursday, March 08, 2012 7:09 AM<br><b>To:</b> Timothy DeWees<br><b>Cc:</b> framers@lists.frameusers.com<br><b>Subject:</b> Re: Copy / paste table cells<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If I were doing the project, I'd take a couple steps backwards, to the HTML file, which I assume is still online.<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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.<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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.<o:p></o:p></p></div><div><p class=MsoNormal>Then bring the cleaned up file into Frame by exporting as a text format FM can deal with -- the comma or tab delimited file.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Art <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'>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><o:p></o:p></p><div><p class=MsoNormal>On Tue, Mar 6, 2012 at 9:41 AM, Timothy DeWees <<a href="mailto:tdewees@charter.net">tdewees@charter.net</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi all,<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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. <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Tim DeWees<o:p></o:p></p></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><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.<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></body></html>