Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Bonni Bonni is offline
external usenet poster
 
Posts: 3
Default delete sewctions of text using find and replace

Hi,
I need to delete certain sections of text in a word doc. and replace it with
','
for example:
the cat sat on the mat
would need to become:
the,mat
i have 4000 lines of this and do not want to have to manually delete all the
uneccessary text.

Any pointers?

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Poprivet Poprivet is offline
external usenet poster
 
Posts: 160
Default delete sewctions of text using find and replace

Bonni wrote:
Hi,
I need to delete certain sections of text in a word doc. and replace
it with ','
for example:
the cat sat on the mat
would need to become:
the,mat
i have 4000 lines of this and do not want to have to manually delete
all the uneccessary text.

Any pointers?


CTRL-H will bring up the Replace dialog box. PUt what you have in the top
line, what you wnat it to be inthe second box, try a couple of replaces and
if it works toyour liking, hit Replace All.


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Bonni Bonni is offline
external usenet poster
 
Posts: 3
Default delete sections of text using find and replace

Hi,
Its a little more complex than that. here is an actual example:

–* AACC - Association Algérienne de Lutte Contre la Corruption (Algeria)
Mailing address: Centre Familial de Ben Aknoun Alger 16 Algeria
Other address: Tel.: Fax: E-mail: Web page: http://www.transparency.org/
Category: 6. CSO Notes:

would need to become:

AACC - Association Algérienne de Lutte Contre la Corruption



any ideas? i know that i would need to do it twice to remove whatever is
before the mail address and that which comes after the address.

thanks.

"Poprivet" wrote:

Bonni wrote:
Hi,
I need to delete certain sections of text in a word doc. and replace
it with ','
for example:
the cat sat on the mat
would need to become:
the,mat
i have 4000 lines of this and do not want to have to manually delete
all the uneccessary text.

Any pointers?


CTRL-H will bring up the Replace dialog box. PUt what you have in the top
line, what you wnat it to be inthe second box, try a couple of replaces and
if it works toyour liking, hit Replace All.



  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default delete sections of text using find and replace

How similar are the entries? and where did the email address come from? and
is this really what you want:

AACC - Association Algérienne de Lutte Contre la Corruption


with no space between the , and the start of the email address.

If you give full information, you will have a much better chance of getting
a useful response.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Bonni" wrote in message
...
Hi,
Its a little more complex than that. here is an actual example:

? AACC - Association Algérienne de Lutte Contre la Corruption (Algeria)
Mailing address: Centre Familial de Ben Aknoun Alger 16 Algeria
Other address: Tel.: Fax: E-mail: Web page: http://www.transparency.org/
Category: 6. CSO Notes:

would need to become:

AACC - Association Algérienne de Lutte Contre la Corruption



any ideas? i know that i would need to do it twice to remove whatever is
before the mail address and that which comes after the address.

thanks.

"Poprivet" wrote:

Bonni wrote:
Hi,
I need to delete certain sections of text in a word doc. and replace
it with ','
for example:
the cat sat on the mat
would need to become:
the,mat
i have 4000 lines of this and do not want to have to manually delete
all the uneccessary text.

Any pointers?


CTRL-H will bring up the Replace dialog box. PUt what you have in the
top
line, what you wnat it to be inthe second box, try a couple of replaces
and
if it works toyour liking, hit Replace All.





  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Bonni Bonni is offline
external usenet poster
 
Posts: 3
Default delete sections of text using find and replace

Hi Doug,
Thanks for the tips. What you say is exactly correct. Basically what i have
is a word document with a list of contacts. From that all i need is the name
and country and email address. Each entry is identically ordered (name,
country, mailing address, other address,tel, fax, email, web page, category,
CSO notes). basically what i want to do is delete everything from 'Mailing
address' to 'email' and replace it with a ',' with no spaces before or after
the comma. i will then be able to save this as *.csv and import it into
Outlook as a contact base (after applying the same process to what appears
after the email address).

I hope this is more informative.

"Doug Robbins - Word MVP" wrote:

How similar are the entries? and where did the email address come from? and
is this really what you want:

AACC - Association Algérienne de Lutte Contre la Corruption


with no space between the , and the start of the email address.

If you give full information, you will have a much better chance of getting
a useful response.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Bonni" wrote in message
...
Hi,
Its a little more complex than that. here is an actual example:

? AACC - Association Algérienne de Lutte Contre la Corruption (Algeria)
Mailing address: Centre Familial de Ben Aknoun Alger 16 Algeria
Other address: Tel.: Fax: E-mail: Web page: http://www.transparency.org/
Category: 6. CSO Notes:

would need to become:

AACC - Association Algérienne de Lutte Contre la Corruption



any ideas? i know that i would need to do it twice to remove whatever is
before the mail address and that which comes after the address.

thanks.

"Poprivet" wrote:

Bonni wrote:
Hi,
I need to delete certain sections of text in a word doc. and replace
it with ','
for example:
the cat sat on the mat
would need to become:
the,mat
i have 4000 lines of this and do not want to have to manually delete
all the uneccessary text.

Any pointers?

CTRL-H will bring up the Replace dialog box. PUt what you have in the
top
line, what you wnat it to be inthe second box, try a couple of replaces
and
if it works toyour liking, hit Replace All.








  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default delete sections of text using find and replace

If the entries are all in the same format. Use the method described at
http://www.gmayor.com/convert_labels...mail_merge.htm to convert them to
a table then either use mail merge to a directory format to extract the bits
you want, or delete the unwanted columns and convert the table back to text.
If the entries are not all the same, then you can use replace to remove the
unwanted similar bits - see
http://www.gmayor.com/replace_using_wildcards.htm .

--

Graham Mayor - Word MVP

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



Bonni wrote:
Hi Doug,
Thanks for the tips. What you say is exactly correct. Basically what
i have is a word document with a list of contacts. From that all i
need is the name and country and email address. Each entry is
identically ordered (name, country, mailing address, other
address,tel, fax, email, web page, category, CSO notes). basically
what i want to do is delete everything from 'Mailing address' to
'email' and replace it with a ',' with no spaces before or after the
comma. i will then be able to save this as *.csv and import it into
Outlook as a contact base (after applying the same process to what
appears after the email address).

I hope this is more informative.

"Doug Robbins - Word MVP" wrote:

How similar are the entries? and where did the email address come
from? and is this really what you want:

AACC - Association Algérienne de Lutte Contre la Corruption


with no space between the , and the start of the email address.

If you give full information, you will have a much better chance of
getting a useful response.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Bonni" wrote in message
...
Hi,
Its a little more complex than that. here is an actual example:

? AACC - Association Algérienne de Lutte Contre la Corruption
(Algeria) Mailing address: Centre Familial de Ben Aknoun Alger 16
Algeria
Other address: Tel.: Fax: E-mail: Web page:
http://www.transparency.org/ Category: 6. CSO Notes:

would need to become:

AACC - Association Algérienne de Lutte Contre la Corruption



any ideas? i know that i would need to do it twice to remove
whatever is before the mail address and that which comes after the
address.

thanks.

"Poprivet" wrote:

Bonni wrote:
Hi,
I need to delete certain sections of text in a word doc. and
replace it with ','
for example:
the cat sat on the mat
would need to become:
the,mat
i have 4000 lines of this and do not want to have to manually
delete all the uneccessary text.

Any pointers?

CTRL-H will bring up the Replace dialog box. PUt what you have in
the top
line, what you wnat it to be inthe second box, try a couple of
replaces and
if it works toyour liking, hit Replace All.



  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Poprivet Poprivet is offline
external usenet poster
 
Posts: 160
Default delete sections of text using find and replace

Can't help when the details needed come in piece-meal. You need to state
the problem correctly but so far still looks like a Replace operation.
Can't help further; too few details.


Bonni wrote:
Hi,
Its a little more complex than that. here is an actual example:

? AACC - Association Algérienne de Lutte Contre la Corruption
(Algeria) Mailing address: Centre Familial de Ben Aknoun Alger 16
Algeria
Other address: Tel.: Fax: E-mail: Web page:
http://www.transparency.org/ Category: 6. CSO Notes:

would need to become:

AACC - Association Algérienne de Lutte Contre la Corruption



any ideas? i know that i would need to do it twice to remove whatever
is before the mail address and that which comes after the address.

thanks.

"Poprivet" wrote:

Bonni wrote:
Hi,
I need to delete certain sections of text in a word doc. and replace
it with ','
for example:
the cat sat on the mat
would need to become:
the,mat
i have 4000 lines of this and do not want to have to manually delete
all the uneccessary text.

Any pointers?


CTRL-H will bring up the Replace dialog box. PUt what you have in
the top line, what you wnat it to be inthe second box, try a couple
of replaces and if it works toyour liking, hit Replace All.




  #8   Report Post  
Posted to microsoft.public.word.docmanagement
Henk57[_14_] Henk57[_14_] is offline
external usenet poster
 
Posts: 1
Default delete sewctions of text using find and replace


Bonni:
What Graham says is indeed the solution in my opinion. In addition,
however, you may need some creativity to make it work for you. If you
convert Text to Table you need to be sure that the end of the record is
marked w/ a hard return and the fields within a record are TABs. You
can then import into Excel smoothly, manipulate columns (remove, change
order, ...) and save the file as a *.csv.
The creativity comes in to get tabs and hard returns appropriately. If
all fields in a record are separated by hard returns too, getting it
into Excel will not help you as all fields are in one column. If you
have no paragraph breaks (except for the last which Word adds by
default), then you need to find a way to automatically create end of
record breaks. This could be TWO consecutive Line breaks, or any other
unique separating series of characters. (Line breaks can be replaced by
tabs, by Replace ^l (small "L") by ^t). Otherwise, assuming you dont
have two e-mail addresses in one record, you could replace the @ by @^p
so the record splits in the middle of the e-mail address. Now yr
records are "skewed", but in a repeated, consistent pattern so can be
fixed in Excel (the email address can be restored w/ CONCATENATE.)
I hope this all makes sense and that you can get it working.
Henk




Graham Mayor;2157696 Wrote:
If the entries are all in the same format. Use the method described at
http://www.gmayor.com/convert_labels...mail_merge.htm to convert
them to
a table then either use mail merge to a directory format to extract the
bits
you want, or delete the unwanted columns and convert the table back to
text.
If the entries are not all the same, then you can use replace to remove
the
unwanted similar bits - see
http://www.gmayor.com/replace_using_wildcards.htm .

--

Graham Mayor - Word MVP

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



Bonni wrote:-
Hi Doug,
Thanks for the tips. What you say is exactly correct. Basically what
i have is a word document with a list of contacts. From that all i
need is the name and country and email address. Each entry is
identically ordered (name, country, mailing address, other
address,tel, fax, email, web page, category, CSO notes). basically
what i want to do is delete everything from 'Mailing address' to
'email' and replace it with a ',' with no spaces before or after the
comma. i will then be able to save this as *.csv and import it into
Outlook as a contact base (after applying the same process to what
appears after the email address).

I hope this is more informative.

"Doug Robbins - Word MVP" wrote:
-
How similar are the entries? and where did the email address come
from? and is this really what you want:

AACC - Association Algérienne de Lutte Contre la Corruption


with no space between the , and the start of the email address.

If you give full information, you will have a much better chance of
getting a useful response.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Bonni" wrote in message
...-
Hi,
Its a little more complex than that. here is an actual example:

? AACC - Association Algérienne de Lutte Contre la Corruption
(Algeria) Mailing address: Centre Familial de Ben Aknoun Alger 16
Algeria
Other address: Tel.: Fax: E-mail: Web page:
http://www.transparency.org/ Category: 6. CSO Notes:

would need to become:

AACC - Association Algérienne de Lutte Contre la Corruption



any ideas? i know that i would need to do it twice to remove
whatever is before the mail address and that which comes after the
address.

thanks.

"Poprivet" wrote:

Bonni wrote:
Hi,
I need to delete certain sections of text in a word doc. and
replace it with ','
for example:
the cat sat on the mat
would need to become:
the,mat
i have 4000 lines of this and do not want to have to manually
delete all the uneccessary text.

Any pointers?

CTRL-H will bring up the Replace dialog box. PUt what you have in
the top
line, what you wnat it to be inthe second box, try a couple of
replaces and
if it works toyour liking, hit Replace All. ---





--
Henk57
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
find, replace, delete Ben Microsoft Word Help 5 May 11th 06 04:06 PM
find and replace = delete Ben Microsoft Word Help 3 May 11th 06 06:13 AM
find/replace in between text [email protected] Microsoft Word Help 3 November 29th 05 09:35 PM
Find and Replace: delete a line & find a number 10 Janis Anna Microsoft Word Help 3 October 23rd 05 05:53 AM
find, block - goto replace or delete Brent Hauver Formatting Long Documents 1 February 4th 05 09:46 PM


All times are GMT +1. The time now is 05:41 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"