Reply
 
Thread Tools Display Modes
  #1   Report Post  
gr8fuldave gr8fuldave is offline
Junior Member
 
Posts: 0
Default Extracting specific words from a document

Hi Folks,

Hello! The solution [a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,} worked great for me when extracting several hundred e-mail addresses from a document.

I am faced with another similar challenge. I have a document that has a multitude of the following:
*lastname,firstname throughout the text (with real last and first names of clients.)

The asterisk is attached to each name.

I need to highlight and copy all the above from the document.

what is the formula to search and highlight *firstname,lastname?

Thanks!
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Lisa Wilke-Thissen Lisa Wilke-Thissen is offline
external usenet poster
 
Posts: 123
Default Extracting specific words from a document

Hi,

[unknown Word version]

I need to highlight and copy all the above from the document.
what is the formula to search and highlight *firstname,lastname?


lastname is followed by what - manual line break, paragrah, more text?

--
Cheers,

Lisa
  #3   Report Post  
gr8fuldave gr8fuldave is offline
Junior Member
 
Posts: 0
Question

Hi Lisa,
This is an exact cut paste from the document:

*Fischer Jr, William O

there are a couple thousand of these I need to extract. I got pretty close and was able to highlight the *lastname, using the following:\*[a-zA-Z0-9\-_.]{1,}...I can't seem to get it to capture the Jr, William O etc.



Quote:
Originally Posted by Lisa Wilke-Thissen View Post
Hi,

[unknown Word version]

I need to highlight and copy all the above from the document.
what is the formula to search and highlight *firstname,lastname?


lastname is followed by what - manual line break, paragrah, more text?

--
Cheers,

Lisa
  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Lisa Wilke-Thissen Lisa Wilke-Thissen is offline
external usenet poster
 
Posts: 123
Default Extracting specific words from a document

Hi,

This is an exact cut paste from the document:
*Fischer Jr, William O


there are a couple thousand of these I need to extract.
I got pretty close and was able to highlight the *lastname,
using the following:\*[a-zA-Z0-9\-_.]{1,}...
I can't seem to get it to capture the Jr, William O etc.


but you need to know, what is following the firstname. Where has Word to
stop highlighting? Is it a full stop, is it a paragraph mark, is it a manual
line break, is it a colon?

--
Cheers,
Lisa

  #5   Report Post  
gr8fuldave gr8fuldave is offline
Junior Member
 
Posts: 0
Unhappy

Hi Lisa,
I really can't tell. i looked at the document in every view type, and it just doesn't show it. I originally received it as .pdf, and converted it to .docx. If you must know, i am trying to extract e-mail address and name for an e-mail campaign for my company. All legitimate, but I can't seem to cull the specific information.

I would be happy to send you a page for research if you think you can help. I'm stumped.

but you need to know, what is following the firstname. Where has Word to
stop highlighting? Is it a full stop, is it a paragraph mark, is it a manual
line break, is it a colon?

--
Cheers,
Lisa[/quote]


  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Lisa Wilke-Thissen Lisa Wilke-Thissen is offline
external usenet poster
 
Posts: 123
Default Extracting specific words from a document

Hi,

I really can't tell. i looked at the document in
every view type, and it just doesn't show it.


but you do know, how to show all formatting marks in a Word document?
http://office.microsoft.com/en-us/wo...010102250.aspx

I would be happy to send you a page for research
if you think you can help.


I think to get the document would help, but it is not necessary. We just
need the information about the systematic:
Where has Word to stop highlighting? Is it a full stop, is it a paragraph
mark, is it a manual line break, is it a colon?
Where does the firstname end?

--
Cheers,
Lisa

  #7   Report Post  
gr8fuldave gr8fuldave is offline
Junior Member
 
Posts: 0
Smile

Quote:
Originally Posted by Lisa Wilke-Thissen View Post
Hi,

I really can't tell. i looked at the document in
every view type, and it just doesn't show it.


but you do know, how to show all formatting marks in a Word document?
http://office.microsoft.com/en-us/wo...010102250.aspx

I would be happy to send you a page for research
if you think you can help.


I think to get the document would help, but it is not necessary. We just
need the information about the systematic:
Where has Word to stop highlighting? Is it a full stop, is it a paragraph
mark, is it a manual line break, is it a colon?
Where does the firstname end?

--
Cheers,
Lisa
Hi Lisa,
Thanks for the tip-each "first name" is followed by a paragraph mark.
  #8   Report Post  
gr8fuldave gr8fuldave is offline
Junior Member
 
Posts: 0
Default

Quote:
Originally Posted by gr8fuldave View Post
Hi Lisa,
Thanks for the tip-each "first name" is followed by a paragraph mark.
the exact format is:
*lastname (including Jr, III, etc), First name(paragraph)

How do I search this string and highlight it and cut/copy?

Thanks!
  #9   Report Post  
Posted to microsoft.public.word.docmanagement
Lisa Wilke-Thissen Lisa Wilke-Thissen is offline
external usenet poster
 
Posts: 123
Default Extracting specific words from a document

Hi,

Thanks for the tip-each "first name" is followed by a paragraph mark.


the exact format is:
*lastname (including Jr, III, etc), First name(paragraph)


using wildcards, you cannot search for a "paragraph mark". So you have to
use the code ^013.

Find | Find what:
\*(*)^013
[= asterix, 0 or more characters, paragraph mark]
Find in: Main document

Now all occurances of "*...........¶" are selected, and you can copy them.

--
Cheers,
Lisa

  #10   Report Post  
gr8fuldave gr8fuldave is offline
Junior Member
 
Posts: 0
Thumbs up

That worked perfectly! WOW you are amazing!

Next question-final for this project (I hope).

I do the search, it highlights all the names as you instructed. I want to cut/paste, but for some reason when I go from "Search" back to document, I control C, it does not cut the highlighted selection.

Can you tell me what I am doing incorrectly?

Thanks so much you are TERRIFIC!

Dave

Quote:
Originally Posted by Lisa Wilke-Thissen View Post
Hi,

Thanks for the tip-each "first name" is followed by a paragraph mark.


the exact format is:
*lastname (including Jr, III, etc), First name(paragraph)


using wildcards, you cannot search for a "paragraph mark". So you have to
use the code ^013.

Find | Find what:
\*(*)^013
[= asterix, 0 or more characters, paragraph mark]
Find in: Main document

Now all occurances of "*...........¶" are selected, and you can copy them.

--
Cheers,
Lisa


  #11   Report Post  
Posted to microsoft.public.word.docmanagement
Peter T. Daniels Peter T. Daniels is offline
external usenet poster
 
Posts: 3,215
Default Extracting specific words from a document

Ctrl-C is Copy. Ctrl-X is Cut to clipboard (which I think is what you said
you want). but after Ctrl-C, it's all on the clipboard ready to be pasted
(Ctrl-V) somewhere else.

On Tuesday, February 11, 2014 2:53:05 PM UTC-5, gr8fuldave wrote:
That worked perfectly! WOW you are amazing!
Next question-final for this project (I hope).
I do the search, it highlights all the names as you instructed. I want
to cut/paste, but for some reason when I go from "Search" back to
document, I control C, it does not cut the highlighted selection.
Can you tell me what I am doing incorrectly?
Thanks so much you are TERRIFIC!

  #12   Report Post  
gr8fuldave gr8fuldave is offline
Junior Member
 
Posts: 0
Default

You would think so! But for some reason, when I try it, it doesn't cut or copy. I am going from my search back to the document (clicking the document) I can see all the highlighted things I want to copy (they have become yellow), but when I Ctrl-C nothing happens...

ugggh!


Quote:
Originally Posted by Peter T. Daniels View Post
Ctrl-C is Copy. Ctrl-X is Cut to clipboard (which I think is what you said
you want). but after Ctrl-C, it's all on the clipboard ready to be pasted
(Ctrl-V) somewhere else.

On Tuesday, February 11, 2014 2:53:05 PM UTC-5, gr8fuldave wrote:
That worked perfectly! WOW you are amazing!
Next question-final for this project (I hope).
I do the search, it highlights all the names as you instructed. I want
to cut/paste, but for some reason when I go from "Search" back to
document, I control C, it does not cut the highlighted selection.
Can you tell me what I am doing incorrectly?
Thanks so much you are TERRIFIC!
  #13   Report Post  
Posted to microsoft.public.word.docmanagement
Peter T. Daniels Peter T. Daniels is offline
external usenet poster
 
Posts: 3,215
Default Extracting specific words from a document

Highlighting isn't Selecting.

On Wednesday, February 12, 2014 7:50:36 PM UTC-5, gr8fuldave wrote:
You would think so! But for some reason, when I try it, it doesn't cut
or copy. I am going from my search back to the document (clicking the
document) I can see all the highlighted things I want to copy (they have
become yellow), but when I Ctrl-C nothing happens...

ugggh!

Peter T. Daniels;495149 Wrote:

Ctrl-C is Copy. Ctrl-X is Cut to clipboard (which I think is what you
said
you want). but after Ctrl-C, it's all on the clipboard ready to be
pasted
(Ctrl-V) somewhere else.


On Tuesday, February 11, 2014 2:53:05 PM UTC-5, gr8fuldave wrote:-
That worked perfectly! WOW you are amazing!
Next question-final for this project (I hope).
I do the search, it highlights all the names as you instructed. I want
to cut/paste, but for some reason when I go from "Search" back to
document, I control C, it does not cut the highlighted selection.
Can you tell me what I am doing incorrectly?
Thanks so much you are TERRIFIC!-

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
Extracting specific Text from Word Document [email protected] Microsoft Word Help 3 November 26th 07 06:32 PM
Counting specific words in a document Luigi Microsoft Word Help 1 September 16th 07 05:14 AM
Extracting specific Excel data into word Nicole Knapp Microsoft Word Help 3 July 12th 07 10:18 PM
Extracting words by their alfabetic order Albana Page Layout 1 July 12th 06 11:23 PM
Counting instances of specific words in a document Michael Z Microsoft Word Help 3 February 20th 05 07:35 PM


All times are GMT +1. The time now is 05:12 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"