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/72596cfc/attachment.htm>