Hi All,
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. Tim From: Art Campbell [mailto:[email protected]] Sent: Thursday, March 08, 2012 7:09 AM To: Timothy DeWees Cc: framers at lists.frameusers.com Subject: Re: Copy / paste table cells If I were doing the project, I'd take a couple steps backwards, to the HTML file, which I assume is still online. 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. 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. 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. Then bring the cleaned up file into Frame by exporting as a text format FM can deal with -- the comma or tab delimited file. Art Art Campbell art.campbell at gmail.com "... In my opinion, there's nothing in this world beats a '52 Vincent and a redheaded girl." -- Richard Thompson No disclaimers apply. DoD 358 I support www.TheGrotonLine.com, hyperlocal news for Groton MA. On Tue, Mar 6, 2012 at 9:41 AM, Timothy DeWees <tdewees at charter.net> wrote: Hi all, 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 1st 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. 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. Tim DeWees _______________________________________________ You are currently subscribed to framers as art.campbell at gmail.com. Send list messages to framers at lists.frameusers.com. To unsubscribe send a blank email to framers-unsubscribe at lists.frameusers.com or visit http://lists.frameusers.com/mailman/options/framers/art.campbell%40gmail.com Send administrative questions to listadmin at frameusers.com. Visit http://www.frameusers.com/ for more resources and info. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.frameusers.com/pipermail/framers/attachments/20120308/cc38e68d/attachment.html>
