[geotso[_2_]]

I have a "table" in plain text like this:

1. [name] [surname] 0:36:27
2. [another name] [and surname] 0:46:27
3. [third name] [and surname] 1:03:42
4. [and so one...] 2:04:18

Whe
- After the order number there is an empty space
- Between [name] [surname] there is an empty space
- Between [surname] [time] there are empty spaces and/or tab characters.

Is there a simple way to convert it to a table (I don't know VBA)?

--
Please remove hyphens to contact me
----- --- -- -- -
geotso
----- --- -- -- -

[Graham Mayor]

Are the names in square brackets?
Are the numbers at the start of each line included?
In the meantime see http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




geotso wrote:
I have a "table" in plain text like this:

1. [name] [surname] 0:36:27
2. [another name] [and surname] 0:46:27
3. [third name] [and surname] 1:03:42
4. [and so one...] 2:04:18

Whe
- After the order number there is an empty space
- Between [name] [surname] there is an empty space
- Between [surname] [time] there are empty spaces and/or tab
characters.
Is there a simple way to convert it to a table (I don't know VBA)?

[geotso[_2_]]

then, "Graham Mayor" climbed to the rostrum and said:
Are the names in square brackets?

No. Just in my sample only

Are the numbers at the start of each line included?

Yes

In the meantime see http://www.gmayor.com/convert_labels...mail_merge.htm

I'm going there right now!

[Suzanne S. Barnhill]

I would start by using wildcards to replace any number of spaces with a tab,
then use Table | Convert | Table to Text, separating at tabs. If the Replace
operation results in multiple tabs between elements, replace those with a
single tab before converting.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"geotso" wrote in message
...
I have a "table" in plain text like this:

1. [name] [surname] 0:36:27
2. [another name] [and surname] 0:46:27
3. [third name] [and surname] 1:03:42
4. [and so one...] 2:04:18

Whe
- After the order number there is an empty space
- Between [name] [surname] there is an empty space
- Between [surname] [time] there are empty spaces and/or tab characters.

Is there a simple way to convert it to a table (I don't know VBA)?

--
Please remove hyphens to contact me
----- --- -- -- -
geotso
----- --- -- -- -

[geotso[_2_]]

then, "Suzanne S. Barnhill" climbed to the rostrum and said:
I would start by using wildcards to replace any number of spaces with a tab,

And what is the expression for this, please?
I've tried " {2,}" (no quotes - starting empty space) and Word (2007) warns
me that the expression is not valid.

then use Table | Convert | Table to Text, separating at tabs. If the Replace
operation results in multiple tabs between elements, replace those with a
single tab before converting.

Once again, what is the expression for "multiple tabs"?
I've tried "^t{2,}" (no quotes) with the same as above results...

Thank you very much

[Suzanne S. Barnhill]

This works for me provided I remember to check the "Use wildcards" box.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"geotso" wrote in message
...
then, "Suzanne S. Barnhill" climbed to the rostrum and said:
I would start by using wildcards to replace any number of spaces with a
tab,

And what is the expression for this, please?
I've tried " {2,}" (no quotes - starting empty space) and Word (2007)
warns me that the expression is not valid.

then use Table | Convert | Table to Text, separating at tabs. If the
Replace
operation results in multiple tabs between elements, replace those with a
single tab before converting.

Once again, what is the expression for "multiple tabs"?
I've tried "^t{2,}" (no quotes) with the same as above results...

Thank you very much

[Jay Freedman]

On Sat, 08 Mar 2008 19:23:26 +0200, geotso wrote:

then, "Suzanne S. Barnhill" climbed to the rostrum and said:
I would start by using wildcards to replace any number of spaces with a tab,

And what is the expression for this, please?
I've tried " {2,}" (no quotes - starting empty space) and Word (2007) warns
me that the expression is not valid.

That expression works in my copy of Word 2007, and it should work in yours. If
you can't make it work, then try surrounding the space character (but not the
{2,}) in square brackets:

[ ]{2,}

Also, in your initial post you mentioned that the name and time may be separated
by an assortment of spaces and tabs. You can replace the whole lot in one
wildcard search by using the expression

[ ^9]{2,}

That is, the space is still in the brackets, plus the numeric code for a tab
character (see http://www.gmayor.com/replace_using_wildcards.htm for a list of
codes).


then use Table | Convert | Table to Text, separating at tabs. If the Replace
operation results in multiple tabs between elements, replace those with a
single tab before converting.

Once again, what is the expression for "multiple tabs"?
I've tried "^t{2,}" (no quotes) with the same as above results...

Thank you very much

To search for multiple tabs, use an expression like the one above with the ^9
code, but leave out the space character. As explained in Graham's article, codes
such as ^t and ^p don't work in the Find What box of a wildcard search, only in
the Replace With box (and in both boxes for a non-wildcard search).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

[Suzanne S. Barnhill]

I also tried [ ]{2,} and found it didn't work because I'd forgotten to check
"Use wildcards." When I did check it, the expression worked without the
brackets, and it's all too easy to get so wrapped up in figuring out the
right search term that you forget to check the box; I'm guessing that's the
OP did.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Jay Freedman" wrote in message
news
On Sat, 08 Mar 2008 19:23:26 +0200, geotso wrote:

then, "Suzanne S. Barnhill" climbed to the rostrum and said:
I would start by using wildcards to replace any number of spaces with a
tab,

And what is the expression for this, please?
I've tried " {2,}" (no quotes - starting empty space) and Word (2007)
warns
me that the expression is not valid.

That expression works in my copy of Word 2007, and it should work in
yours. If
you can't make it work, then try surrounding the space character (but not
the
{2,}) in square brackets:

[ ]{2,}

Also, in your initial post you mentioned that the name and time may be
separated
by an assortment of spaces and tabs. You can replace the whole lot in one
wildcard search by using the expression

[ ^9]{2,}

That is, the space is still in the brackets, plus the numeric code for a
tab
character (see http://www.gmayor.com/replace_using_wildcards.htm for a
list of
codes).


then use Table | Convert | Table to Text, separating at tabs. If the
Replace
operation results in multiple tabs between elements, replace those with
a
single tab before converting.

Once again, what is the expression for "multiple tabs"?
I've tried "^t{2,}" (no quotes) with the same as above results...

Thank you very much

To search for multiple tabs, use an expression like the one above with the
^9
code, but leave out the space character. As explained in Graham's article,
codes
such as ^t and ^p don't work in the Find What box of a wildcard search,
only in
the Replace With box (and in both boxes for a non-wildcard search).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so all may benefit.

[Jay Freedman]

If you use a wildcard expression but forget to check the "Use wildcards" box, it
simply won't find anything. But if the box is checked and the expression isn't
correctly formed according to the wildcard rules, then you get a message box
saying that the search expression isn't valid. From geotso's post, I gathered
that he saw the message box.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all
may benefit.

On Sat, 8 Mar 2008 13:17:34 -0600, "Suzanne S. Barnhill"
wrote:

I also tried [ ]{2,} and found it didn't work because I'd forgotten to check
"Use wildcards." When I did check it, the expression worked without the
brackets, and it's all too easy to get so wrapped up in figuring out the
right search term that you forget to check the box; I'm guessing that's the
OP did.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Jay Freedman" wrote in message
news
On Sat, 08 Mar 2008 19:23:26 +0200, geotso wrote:

then, "Suzanne S. Barnhill" climbed to the rostrum and said:
I would start by using wildcards to replace any number of spaces with a
tab,

And what is the expression for this, please?
I've tried " {2,}" (no quotes - starting empty space) and Word (2007)
warns
me that the expression is not valid.

That expression works in my copy of Word 2007, and it should work in
yours. If
you can't make it work, then try surrounding the space character (but not
the
{2,}) in square brackets:

[ ]{2,}

Also, in your initial post you mentioned that the name and time may be
separated
by an assortment of spaces and tabs. You can replace the whole lot in one
wildcard search by using the expression

[ ^9]{2,}

That is, the space is still in the brackets, plus the numeric code for a
tab
character (see http://www.gmayor.com/replace_using_wildcards.htm for a
list of
codes).


then use Table | Convert | Table to Text, separating at tabs. If the
Replace
operation results in multiple tabs between elements, replace those with
a
single tab before converting.

Once again, what is the expression for "multiple tabs"?
I've tried "^t{2,}" (no quotes) with the same as above results...

Thank you very much

To search for multiple tabs, use an expression like the one above with the
^9
code, but leave out the space character. As explained in Graham's article,
codes
such as ^t and ^p don't work in the Find What box of a wildcard search,
only in
the Replace With box (and in both boxes for a non-wildcard search).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so all may benefit.

[geotso[_2_]]

That expression works in my copy of Word 2007, and it should work in yours. If
you can't make it work, then try surrounding the space character (but not the
{2,}) in square brackets:

[ ]{2,}

It definitely doesn't work

I've tried both suggestions, to no avail...
I've also turned on the "Show all formatting marks" just in case I was wrong
about the empty spaces, and they was really there! I counted 13 dot marks
just between the first surname and his time.

I've also tried the ^s character (non-breaking space), just to receive the
same disappointing error message

[Suzanne S. Barnhill]

How very odd! Failing wild cards, you can always just search for two spaces
repeatedly until Find returns no results.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"geotso" wrote in message
...

That expression works in my copy of Word 2007, and it should work in
yours. If
you can't make it work, then try surrounding the space character (but not
the
{2,}) in square brackets:

[ ]{2,}

It definitely doesn't work

I've tried both suggestions, to no avail...
I've also turned on the "Show all formatting marks" just in case I was
wrong about the empty spaces, and they was really there! I counted 13 dot
marks just between the first surname and his time.

I've also tried the ^s character (non-breaking space), just to receive the
same disappointing error message

[Terry Farrell]

Just to clarify Suzanne's advice...

After the replace, you will see the list looking like:

[1.] tab [name] tab [surname] tab [0:36:27] return

Then when you select the list and use convert Text to Table choosing the TAB
as the separator, you will have a four column table. If you need the empty
space afterwards, you simply select the column to the right and chose
Insert, Column to the Left (or vice versa).

BTW, if you are ever going to place the table in a spreadsheet, you should
consider changing your order numbering system because it may be confused as
the standard time format (hours:minutes:seconds): it certainly confused me
at first glance.

Terry

"geotso" wrote in message
...
I have a "table" in plain text like this:

1. [name] [surname] 0:36:27
2. [another name] [and surname] 0:46:27
3. [third name] [and surname] 1:03:42
4. [and so one...] 2:04:18

Whe
- After the order number there is an empty space
- Between [name] [surname] there is an empty space
- Between [surname] [time] there are empty spaces and/or tab characters.

Is there a simple way to convert it to a table (I don't know VBA)?

--
Please remove hyphens to contact me
----- --- -- -- -
geotso
----- --- -- -- -