Two col table from text?

[Terry Pinnell]

I have a long list of N References. Here are the first couple. What's
the simplest way to get these into an N row by 2 column table, with
author in first col and details in second please?
-------
Alkire, A.A. and Brunse, A.J. (1974)
Impact and possible causality from videotape feedback in marital
therapy. Journal of consulting and clinical psychology, 39, 203-210.

Bandura, A. (1986)
Social Foundations of Thought and Action: A Social Cognitive Theory.
Eaglewood Cliffs, NJ: Prentice Hall.

 

[Thomas A. Rowe]

If these are hard copy pages or you can print them and then scan them into something like OmniPage
(http://www.omnipage.com/omnipage/), where you can convert them into a useable format, you will have
to cut and paste.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Stephen Travis]

You'll have to edit the text so that the columns are separated by Tabs. You'll need an editor, like MS-Word, that can find Paragraph
Marks and replace them with Tab Character.
In MS-Word, you could try to replace the )^p with )^t to identify the end of the author.

Once you've got your tabs in the right place, paste the text into Notepad and then into FP inside a 'Formatted' style (<pre>) and
use Table...Convert...Text To Table.

You can also paste the MS-Word text into;
http://home.att.net/~codeLibrary/HTML/html_table_p.htm

 

[Wally S]

Easier to do the whole thing in Word. What version of Word are you using?
When you "convert text to table," Word should ask you how many columns you
want. I just checked it out by making a quick list similar to yours, and it
worked fine. I got a two-column table. Be sure that each item ends with the
same mark like a tab or an enter. Then use the "convert table to text"
feature . It will be easy. Then you can just use Windows Explorer to drag
your Word document onto an open page in FP. Then, you may want to re-format
the table borders, etc. to your needs. I do this kind of thing all the time,
and I never have a problem.

Wally S

You'll have to edit the text so that the columns are separated by Tabs.

You'll need an editor, like MS-Word, that can find Paragraph

Marks and replace them with Tab Character.
In MS-Word, you could try to replace the )^p with )^t to identify the end of the author.

Once you've got your tabs in the right place, paste the text into Notepad

use Table...Convert...Text To Table.

You can also paste the MS-Word text into;
http://home.att.net/~codeLibrary/HTML/html_table_p.htm

 

[=?iso-8859-1?Q?Crash_Gordon=AE?=]

or excel


| Easier to do the whole thing in Word. What version of Word are you using?
| When you "convert text to table," Word should ask you how many columns you
| want. I just checked it out by making a quick list similar to yours, and it
| worked fine. I got a two-column table. Be sure that each item ends with the
| same mark like a tab or an enter. Then use the "convert table to text"
| feature . It will be easy. Then you can just use Windows Explorer to drag
| your Word document onto an open page in FP. Then, you may want to re-format
| the table borders, etc. to your needs. I do this kind of thing all the time,
| and I never have a problem.
|
| Wally S
|
|
| | > You'll have to edit the text so that the columns are separated by Tabs.
| You'll need an editor, like MS-Word, that can find Paragraph
| > Marks and replace them with Tab Character.
| > In MS-Word, you could try to replace the )^p with )^t to identify the
| end of the author.
| >
| > Once you've got your tabs in the right place, paste the text into Notepad
| and then into FP inside a 'Formatted' style (<pre>) and
| > use Table...Convert...Text To Table.
| >
| > You can also paste the MS-Word text into;
| > http://home.att.net/~codeLibrary/HTML/html_table_p.htm
| >
| > --
| >
| > Stephen Travis,
| > Microsoft MVP - FrontPage
| >
| | > > I have a long list of N References. Here are the first couple. What's
| > > the simplest way to get these into an N row by 2 column table, with
| > > author in first col and details in second please?
| > > -------
| > > Alkire, A.A. and Brunse, A.J. (1974)
| > > Impact and possible causality from videotape feedback in marital
| > > therapy. Journal of consulting and clinical psychology, 39, 203-210.
| > >
| > > Bandura, A. (1986)
| > > Social Foundations of Thought and Action: A Social Cognitive Theory.
| > > Eaglewood Cliffs, NJ: Prentice Hall.
| > > -------
| > >
| > > The Authors and associated Details are separated by paragraph marks.
| > > Using Convert>Text to Table gives me a one column table.
| > >
| > > --
| > > Terry, West Sussex, UK
| > >
| >
| >
|
|

 

[Terry Pinnell]

If these are hard copy pages or you can print them and then scan them into something like OmniPage
(http://www.omnipage.com/omnipage/), where you can convert them into a useable format, you will have
to cut and paste.

Thanks, but no hard copy. (And it would go against the grain a bit
anyway to convert to PAPER <g>). The list started as a table in Word,
but a direct copy and paste into the FP page somehow chopped off the
LH side of text in col 1.

 

[Terry Pinnell]

You'll have to edit the text so that the columns are separated by Tabs. You'll need an editor, like MS-Word, that can find Paragraph
Marks and replace them with Tab Character.
In MS-Word, you could try to replace the )^p with )^t to identify the end of the author.

Once you've got your tabs in the right place, paste the text into Notepad and then into FP inside a 'Formatted' style (<pre>) and
use Table...Convert...Text To Table.

You can also paste the MS-Word text into;
http://home.att.net/~codeLibrary/HTML/html_table_p.htm

Thanks, I'll try that - although I was hoping to avoid the chore of
manual editing. Might be almost as fast to drag each cell into the
blank table?

Anyone have any explanation why a direct copy/paste of the source Word
table into FP results in the LH side being 'chopped off'. Same result
if you convert Word to HTML. But the text *is* apparently still in
that left column, because View>Print Layout shows the full table. Yet
I just can't get it to display on an FP page.

 

[Terry Pinnell]

Easier to do the whole thing in Word. What version of Word are you using?
When you "convert text to table," Word should ask you how many columns you
want. I just checked it out by making a quick list similar to yours, and it
worked fine. I got a two-column table. Be sure that each item ends with the
same mark like a tab or an enter. Then use the "convert table to text"
feature . It will be easy. Then you can just use Windows Explorer to drag
your Word document onto an open page in FP. Then, you may want to re-format
the table borders, etc. to your needs. I do this kind of thing all the time,
and I never have a problem.

Thanks. But as you've probably seen from my subsequent replies to
Thomas and Stephen, the original *was* in a Word 2000 table.
Converting or copy/paste (or dragging) doesn't seem to work, chopping
off LH part of first (author) column. I suspect it's something obvious
I'm missing, maybe to do with table borders or margins etc, but so far
haven't stumbled across the answer!

Here's an illustration showing before and after:
http://www.terrypin.dial.pipex.com/Misc/WordTable.gif

 

[Terry Pinnell]

Thanks. But as you've probably seen from my subsequent replies to
Thomas and Stephen, the original *was* in a Word 2000 table.
Converting or copy/paste (or dragging) doesn't seem to work, chopping
off LH part of first (author) column. I suspect it's something obvious
I'm missing, maybe to do with table borders or margins etc, but so far
haven't stumbled across the answer!

Here's an illustration showing before and after:
http://www.terrypin.dial.pipex.com/Misc/WordTable.gif

I should add that examining the HTML code shows the familiar mess of
'mso' stuff. But there's also a *negative* margin setting (-42.5pts)
which presumably is at the root of this. What should be a trivial task
(shifting a table from on MS Office application to another) seems to
be so tricky!

 

[Terry Pinnell]

Easier to do the whole thing in Word. What version of Word are you using?
When you "convert text to table," Word should ask you how many columns you
want. I just checked it out by making a quick list similar to yours, and it
worked fine. I got a two-column table. Be sure that each item ends with the
same mark like a tab or an enter. Then use the "convert table to text"
feature . It will be easy. Then you can just use Windows Explorer to drag
your Word document onto an open page in FP. Then, you may want to re-format
the table borders, etc. to your needs. I do this kind of thing all the time,
and I never have a problem.

Since my earlier replies, pleased to report I finally did it. Not sure
if I folowed *exactly* your approach, but if not, very similar. The
key steps wer:
1. Use Convert to Text on the original Word table, using TABS (not the
default para marks) as the separators.
2. Then reverse that, i.e. Convert Text to Table.
3. Then open that 'tabbed' table in WordPad (as per tip from you in
similar context some weeks ago) and copying to clipboard.
4. Paste it into FP 2000 and tidy up.

Does that look OK? Were there any redundant or inefficient steps?

Must try to remember this for next time. Still think it should be
easier...!

 

[Wally S]

I don't do a copy/paste. I just drag the whole Word file from Windows
Explorer onto an open page in FP, and it works fine. Tables also come out
okay. I've been doing it for the last six years.

Wally S