Copy / paste table cells

[Timothy DeWees]

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:art.campbell at gmail.com] 
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-frameusers.com/attachments/20120308/cc38e68d/attachment.htm>