Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
|
|||
|
|||
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. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
|
|||
|
|||
Quote:
Thanks for the tip-each "first name" is followed by a paragraph mark. |
#8
|
|||
|
|||
Quote:
*lastname (including Jr, III, etc), First name(paragraph) How do I search this string and highlight it and cut/copy? Thanks! |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
|
|||
|
|||
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:
|
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
|
|||
|
|||
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:
|
#13
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting specific Text from Word Document | Microsoft Word Help | |||
Counting specific words in a document | Microsoft Word Help | |||
Extracting specific Excel data into word | Microsoft Word Help | |||
Extracting words by their alfabetic order | Page Layout | |||
Counting instances of specific words in a document | Microsoft Word Help |