This is Interesting: Free Magazines for Graphics designers and webmasters  


Home > Archive > Front Page > April 2004 > Two col table from text?





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Two col table from text?
Terry Pinnell

2004-04-29, 5:39 pm

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

Thomas A. Rowe

2004-04-29, 5:39 pm

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Terry Pinnell" <terrypin@dial.pipex.com> wrote in message
news:89m290dgfgp3d7nahn9fbqisrq01an8jur@4ax.com...
> 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
>



Stephen Travis

2004-04-29, 5:39 pm

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

"Terry Pinnell" <terrypin@dial.pipex.com> wrote in message news:89m290dgfgp3d7nahn9fbqisrq01an8jur@4ax.com...
> 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
>



Wally S

2004-04-29, 10:34 pm

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


"Stephen Travis" <stravis@iname.com> wrote in message
news:eTADCaiLEHA.1312@TK2MSFTNGP12.phx.gbl...
> 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
>
> "Terry Pinnell" <terrypin@dial.pipex.com> wrote in message

news:89m290dgfgp3d7nahn9fbqisrq01an8jur@4ax.com...
>
>



Crash Gordon®

2004-04-30, 4:30 am

or excel


"Wally S" <hiwally@earthlink.net> wrote in message =
news:%23iEHNMlLEHA.3516@TK2MSFTNGP11.phx.gbl...
| 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.
|=20
| Wally S
|=20
|=20
| "Stephen Travis" <stravis@iname.com> wrote in message
| news:eTADCaiLEHA.1312@TK2MSFTNGP12.phx.gbl...
| > 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
| >
| > --=20
| >
| > Stephen Travis,
| > Microsoft MVP - FrontPage
| >
| > "Terry Pinnell" <terrypin@dial.pipex.com> wrote in message
| news:89m290dgfgp3d7nahn9fbqisrq01an8jur@4ax.com...
| > > 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.
| > >
| > > --=20
| > > Terry, West Sussex, UK
| > >
| >
| >
|=20
|
Terry Pinnell

2004-04-30, 4:30 am

"Thomas A. Rowe" <tarowe@mvps.org> wrote:

>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, West Sussex, UK

Terry Pinnell

2004-04-30, 4:30 am

"Stephen Travis" <stravis@iname.com> wrote:

>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, West Sussex, UK

Terry Pinnell

2004-04-30, 7:28 am

"Wally S" <hiwally@earthlink.net> wrote:

>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, West Sussex, UK

Terry Pinnell

2004-04-30, 7:28 am

Terry Pinnell <terrypin@dial.pipex.com> wrote:

>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, West Sussex, UK

Terry Pinnell

2004-04-30, 9:29 am

"Wally S" <hiwally@earthlink.net> wrote:

>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 qqick 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 i tab or an entez. Then use the "convert table tk 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 jot, 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 frkm you ij
similar context some wmeks ago) and copying to clipboard.
4. Paste it into FP 2000 and tidy up.

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

Must try tk remember this bor next time. Still think it should be
easier...!

--
Terry, West Sussex, UK

Wally S

2004-04-30, 5:33 pm

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

"Terry Pinnell" <terrypin@dial.pipex.com> wrote in message
news:5vt3901onf0o446ukp0rf6q7na4c2ln78q@4ax.com...
> "Stephen Travis" <stravis@iname.com> wrote:
>
You'll need an editor, like MS-Word, that can find Paragraph[color=darkred]
end of the author.[color=darkred]
and then into FP inside a 'Formatted' style (<pre> ) and[color=darkred]
>
> 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, West Sussex, UK
>



Sponsored Links


Copyright 2003 - 2008 forum4designers.com  Software forum  Computer Hardware reviews