Search and Replace within a table

  • Thread starter Thread starter Bogey Man
  • Start date Start date
B

Bogey Man

I am using Word 2000 and would like to be able to do a search for a colon
followed by a space (: ) and delete the colon followed by a space, and
everything that follows to the end of the sell.

Any help would be appreciated.
 
You can use:
\: [+0-9A-z&./,)({}; –_-]{1,}
in the Find field, turn "use Wildcards" on under the More button.
This will find all text after a ": " upto a Paragraph Mark. So if you have
separate paragraphes in the cell, the remaining text will not be found. The
code for Paragraph Mark cannot be used when in Wildcards mode. Also if it was
you would find the whole document after the first occurance of ": " ;-)

Hope this helps
DeanH
 
^13 can be used in the wildcard mode to find a paragraph break
See http://www.gmayor.com/replace_using_wildcards.htm

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

My web site www.gmayor.com

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

You can use:
\: [+0-9A-z&./,)({}; -_-]{1,}
in the Find field, turn "use Wildcards" on under the More button.
This will find all text after a ": " upto a Paragraph Mark. So if you
have separate paragraphes in the cell, the remaining text will not be
found. The code for Paragraph Mark cannot be used when in Wildcards
mode. Also if it was you would find the whole document after the
first occurance of ": " ;-)

Hope this helps
DeanH

Bogey Man said:
I am using Word 2000 and would like to be able to do a search for a
colon followed by a space (: ) and delete the colon followed by a
space, and everything that follows to the end of the sell.

Any help would be appreciated.
 
Very true Graham, but what I meant was that it does not want to work within
the variables listing. Do you know of a code that means "all characters upto
end of line/paragraph"?
DeanH

Graham Mayor said:
^13 can be used in the wildcard mode to find a paragraph break
See http://www.gmayor.com/replace_using_wildcards.htm

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

My web site www.gmayor.com

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

You can use:
\: [+0-9A-z&./,)({}; -_-]{1,}
in the Find field, turn "use Wildcards" on under the More button.
This will find all text after a ": " upto a Paragraph Mark. So if you
have separate paragraphes in the cell, the remaining text will not be
found. The code for Paragraph Mark cannot be used when in Wildcards
mode. Also if it was you would find the whole document after the
first occurance of ": " ;-)

Hope this helps
DeanH

Bogey Man said:
I am using Word 2000 and would like to be able to do a search for a
colon followed by a space (: ) and delete the colon followed by a
space, and everything that follows to the end of the sell.

Any help would be appreciated.
 
Or even upto End of Cell. Why is there no search code for the End of Table
Cell character?

DeanH said:
Very true Graham, but what I meant was that it does not want to work within
the variables listing. Do you know of a code that means "all characters upto
end of line/paragraph"?
DeanH

Graham Mayor said:
^13 can be used in the wildcard mode to find a paragraph break
See http://www.gmayor.com/replace_using_wildcards.htm

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

My web site www.gmayor.com

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

You can use:
\: [+0-9A-z&./,)({}; -_-]{1,}
in the Find field, turn "use Wildcards" on under the More button.
This will find all text after a ": " upto a Paragraph Mark. So if you
have separate paragraphes in the cell, the remaining text will not be
found. The code for Paragraph Mark cannot be used when in Wildcards
mode. Also if it was you would find the whole document after the
first occurance of ": " ;-)

Hope this helps
DeanH

:

I am using Word 2000 and would like to be able to do a search for a
colon followed by a space (: ) and delete the colon followed by a
space, and everything that follows to the end of the sell.

Any help would be appreciated.
 
You cannot search for the end of cell character, what I was implying was
that you could insert ^13 to find paragraph breaks within a cell. There was
nothing wrong with your approach (though it could be simplified) eg

(*): [^13^32-^255]{1,}
replace with
\1
will find most stuff that is likely to be there.

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

My web site www.gmayor.com

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

Or even upto End of Cell. Why is there no search code for the End of
Table Cell character?

DeanH said:
Very true Graham, but what I meant was that it does not want to work
within the variables listing. Do you know of a code that means "all
characters upto end of line/paragraph"?
DeanH

Graham Mayor said:
^13 can be used in the wildcard mode to find a paragraph break
See http://www.gmayor.com/replace_using_wildcards.htm

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

My web site www.gmayor.com

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


DeanH wrote:
You can use:
\: [+0-9A-z&./,)({}; -_-]{1,}
in the Find field, turn "use Wildcards" on under the More button.
This will find all text after a ": " upto a Paragraph Mark. So if
you have separate paragraphes in the cell, the remaining text will
not be found. The code for Paragraph Mark cannot be used when in
Wildcards mode. Also if it was you would find the whole document
after the first occurance of ": " ;-)

Hope this helps
DeanH

:

I am using Word 2000 and would like to be able to do a search for
a colon followed by a space (: ) and delete the colon followed by
a space, and everything that follows to the end of the sell.

Any help would be appreciated.
 
Thank you very much. That works like a charm on the test data that I have.
This will certainly save me a lot of work.

Ron


DeanH said:
You can use:
\: [+0-9A-z&./,)({}; –_-]{1,}
in the Find field, turn "use Wildcards" on under the More button.
This will find all text after a ": " upto a Paragraph Mark. So if you have
separate paragraphes in the cell, the remaining text will not be found.
The
code for Paragraph Mark cannot be used when in Wildcards mode. Also if it
was
you would find the whole document after the first occurance of ": " ;-)

Hope this helps
DeanH

Bogey Man said:
I am using Word 2000 and would like to be able to do a search for a colon
followed by a space (: ) and delete the colon followed by a space, and
everything that follows to the end of the sell.

Any help would be appreciated.
 
Back
Top