Converet plain text to table

G

Graham Mayor

Are you using English regional settings? If not you will probably have to
use separators associated with your local region. In particular some
languages require a semi colon in place of a comma.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

then, "Graham Mayor" climbed to the rostrum and said:
Send me a sample of the document to the link on my web site so that
I can

you (and everyone) can get it from here: http://geotso.com/sample.aspx
check that we are all singing from the same hymn sheet, however in
the meantime try a search for

([0-9]{1,}.)[ ]{1,}([A-Za-z]{1,})[ ]{1,}([A-Za-z]{1,})[
^0160^t]{1,}([0-9]) replace with
\1^t\2^t\3^t\4

with the wildcard option set.
The same "invalid expression" message box :(
 
T

Terry Farrell

I've looked at your document and there is no need for any of this
complication at all. Just use the Replace dialog to Find: ^w and Replace ^t.
No Wildcard needed.

Multiple tabs are recognized as whites space as are the single and multiple
manual spaces. So a single pass does exactly what you need. Once you have
done this, go through the document again before creating the table to
correct the few errors where spaces were missing or an extra space has been
added. These are easy to spot and there are only a few: it will be easier to
correct before conversion than after conversion.

Once you are happy with it, select the list and use the Text to Table
conversion.

If you have missed a mistake (a missing or extra tab) and the table looks
wrong, use UNDO immediately to revert back to the text list to correct the
error before using the Text to Table again.

--
Terry Farrell - MSWord MVP

geotso said:
then, "Graham Mayor" climbed to the rostrum and said:
Send me a sample of the document to the link on my web site so that I can

you (and everyone) can get it from here: http://geotso.com/sample.aspx
check that we are all singing from the same hymn sheet, however in the
meantime try a search for

([0-9]{1,}.)[ ]{1,}([A-Za-z]{1,})[ ]{1,}([A-Za-z]{1,})[
^0160^t]{1,}([0-9])
replace with
\1^t\2^t\3^t\4

with the wildcard option set.
The same "invalid expression" message box :(
 
G

geotso

then, "Graham Mayor" climbed to the rostrum and said:
Are you using English regional settings? If not you will probably have to
use separators associated with your local region. In particular some
languages require a semi colon in place of a comma.

my goodness!!! That's it!!!

Thank you, thank you, and thank you!!! (Not to mention how much I thank you!!!)
 
G

geotso

then, "Terry Farrell" climbed to the rostrum and said:
I've looked at your document and there is no need for any of this
complication at all. Just use the Replace dialog to Find: ^w and Replace
^t. No Wildcard needed.
I've tried it and it works just fine. Thank you very much!

However, Graham's last post was the real answer on why wildcards expressions
don't work in my Word, and that's why he owns more thanks than you! :)
 
G

Graham Mayor

You are welcome :)
Glad we got to the bottom of the problem.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
T

Terry Farrell

I'm not at all jealous in any way!

Terry

geotso said:
then, "Terry Farrell" climbed to the rostrum and said:
I've tried it and it works just fine. Thank you very much!

However, Graham's last post was the real answer on why wildcards
expressions don't work in my Word, and that's why he owns more thanks than
you! :)
 
S

Suzanne S. Barnhill

I should have twigged this earlier on, but your English was so good that it
was only in the last post or two that I began to wonder if you were
somewhere exotic. <g>
 
G

geotso

It seems that OE you use as newsreader, adds a header "X-RFC2646:
Format=Flowed; Response" in your posts (Graham's post, too) that prevents my
Thunderbird from including the previous messages, along with my answer, when
I post back to you (or to Graham).

Could you please tell me how you edit the headers in OE, or it's a
server-side setting?

Thank you and sorry for the off-topic post...
 
S

Suzanne S. Barnhill

I'm afraid I have no expertise in this area, but at least it explains your
failure to quote. I'm using OE out of the box, with no special settings or
editing of the header.
 
B

Bob Buckland ?:-\)

Hi Geotso,

Thunderbird usually doesn't have an issue with that.

In Thunderbird check in
Tools=>Account Settings=>Composition & Addressing
to see if you've turned on the option to

'Automatically quote the original message when replying'

In viewing your message in Thunderbird it's showing Greek (ISO-8859-7) for text encoding.
In viewing in Outlook Express it shows Western Europe (Windows)
but changing didn't stop Thunderbird from including the original message in the reply.

==============
It seems that OE you use as newsreader, adds a header "X-RFC2646:
Format=Flowed; Response" in your posts (Graham's post, too) that prevents my
Thunderbird from including the previous messages, along with my answer, when
I post back to you (or to Graham).

Could you please tell me how you edit the headers in OE, or it's a
server-side setting?

Thank you and sorry for the off-topic post... >>
--

Bob Buckland ?:)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
 
S

Suzanne S. Barnhill

When I reply to geotso, my default encoding is Greek; I changed it to
Western European (Windows) for my latest reply just in case that might make
any difference.
 
G

geotso

then, "Bob Buckland ?:)" climbed to the rostrum and said:
Hi Geotso,

Thunderbird usually doesn't have an issue with that.

In Thunderbird check in
Tools=>Account Settings=>Composition & Addressing
to see if you've turned on the option to

'Automatically quote the original message when replying'
It's turned on alright. After all, as you can see, in this answer TB does
quotes the original messages; and that's because (in my opinion) in your
message's source there isn't the reference "X-RFC2646: Format=Flowed; Response".
In viewing your message in Thunderbird it's showing Greek (ISO-8859-7) for text encoding.
In viewing in Outlook Express it shows Western Europe (Windows)
but changing didn't stop Thunderbird from including the original message in the reply.
That confirms once again that the problem is in the reference I said and not
anywhere else...
 
S

Suzanne S. Barnhill

I note that in the reply in which I changed the format from Greek to Western
European, the header says "X-RFC2646: Format=Flowed; Original." See what
happens if you reply to that one.
 
G

geotso

then, "Suzanne S. Barnhill" climbed to the rostrum and said:
I note that in the reply in which I changed the format from Greek to Western
European, the header says "X-RFC2646: Format=Flowed; Original." See what
happens if you reply to that one.
I'm afraid the same :(

(I was already aware that this reference acts the same way, but I hadn't
mentioned it till now, as it doesn't appear in the current situation -the
posts I've mentioned as example).

Well, thank you very much for your time. As about the problem I'll see what
can I do with the guys from Mozilla/Thunderbird discussion group, where I've
posted the problem too.

Thanks again...
 
S

Suzanne S. Barnhill

It may well have to do with OE's nonconforming use of the -- for signatures.
I forget the details, but there's possibly something about an extra space
after the hyphens signaling the end of the message? I've removed the space
from this message. Does that make a difference?
 
B

Bob Buckland ?:-\)

Hi Geotso,

In using thunderbird I don't have a problem replying to messages that have the RFC2646 reference in the heading.

============
I'm afraid the same :(

(I was already aware that this reference acts the same way, but I hadn't
mentioned it till now, as it doesn't appear in the current situation -the
posts I've mentioned as example).

Well, thank you very much for your time. As about the problem I'll see what
can I do with the guys from Mozilla/Thunderbird discussion group, where I've
posted the problem too.

Thanks again... >>
--

Bob Buckland ?:)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
 
G

geotso

wow!

I have never heard about it before!
And yes! that's it!

then, "Suzanne S. Barnhill" climbed to the rostrum and said:
 
S

Suzanne S. Barnhill

Well, short of remembering to remove the space from the signature every time
I post (or using a different newsreader), I don't guess there's much I can
do; this is a "bug" in OE that the OE MVPs have been hammering MS about for
years.
 
G

Gordon

Suzanne said:
Well, short of remembering to remove the space from the signature every time
I post (or using a different newsreader), I don't guess there's much I can
do; this is a "bug" in OE that the OE MVPs have been hammering MS about for
years.

Cured with OEQuotefix AFAIR....
 
G

geotso

then, "Gordon" climbed to the rostrum and said:
Cured with OEQuotefix AFAIR....

which, is only used (as far as I can presume from my experience) by less
than 1% of the OE users.

The good news are that Windows mail (Vista) isn't infected from the disease
(at least in this area :) )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top