A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Extract phone number from word file



 
 
Thread Tools Display Modes
  #1  
Old June 14th 12, 10:56 PM
Don Lincoln Don Lincoln is offline
Junior Member
 
First recorded activity by WordBanter: Jun 2012
Posts: 0
Smile Extract phone number from word file

Hello

Iím looking for a word macro that will extract numbers from a word file

Its has bunch of numbers. The format of those numbers are ###+###-####, so itís a 10 digit format after first 3 digits there is a plus sign and then after 3 digits there is a minus sign and then the last 4 digits.

What the macro should do is find the phone number and extract that into a new word window and then if the there is a DUPLICATE OF THAT NUMBER then the word should SKIP THAT NUMBER. and then search and extract the next number since the file has lots of duplcate number and i only need unique numbers.

Below is the sample data,



data data data data data data data data data data data data data data data 951+907-3887 data data data data data data data data data data data data data data data 951+907-3887 data data data data data data data data data data data data data data data 951+907-3887 data data data data data data data data data data data data data data data 916+555-1212 data data data data data data data data data data data data data data data 916+555-1212 data data data data data data data data data data data data data data data


Thanks.
Ads
  #2  
Old June 15th 12, 07:12 AM posted to microsoft.public.word.docmanagement
Lisa Wilke-Thissen
external usenet poster
 
Posts: 123
Default Extract phone number from word file

Hi,

I 'm looking for a word macro that will
extract numbers from a word file


which version of Word?

The format of those numbers are ###+###-####,


No macro, but you can choose the "Find" command to select all those
numbers. And then copy and paste them into another document (I would
prefer an Excel sheet):

1. Ctrl + H | Find | More
2. Find what: ^#^#^#+^#^#^#-^#^#^#^#
3. Find in: Main document

All instances will be selected. So you can copy/paste them at once.

In Excel 2010 you can easily remove duplicates:
On the Data tab, in the Data Tools group, click Remove Duplicates.

--
Cheers
Lisa [MS MVP Word]


  #3  
Old July 2nd 12, 12:20 PM posted to microsoft.public.word.docmanagement
Annie Calvert
external usenet poster
 
Posts: 1
Default Extract phone number from word file

Row.Filtered- the easiest method of displaying or hiding data.With this method the programmer has to control row visibility manually.
http://www.dapfor.com/en/net-suite/n...data-filtering

On Thursday, June 14, 2012 5:56 PM Don Lincoln wrote:


Hello

Iím looking for a word macro that will extract numbers from a word file

Its has bunch of numbers. The format of those numbers are ###+###-####,
so itís a 10 digit format after first 3 digits there is a plus sign and
then after 3 digits there is a minus sign and then the last 4 digits.

What the macro should do is find the phone number and extract that into
a new word window and then if the there is a DUPLICATE OF THAT NUMBER
then the word should SKIP THAT NUMBER. and then search and extract the
next number since the file has lots of duplcate number and i only need
unique numbers.

Below is the sample data,



data data data data data data data data data data data data data data
data 951+907-3887 data data data data data data data data data data data
data data data data 951+907-3887 data data data data data data data data
data data data data data data data 951+907-3887 data data data data data
data data data data data data data data data data 916+555-1212 data data
data data data data data data data data data data data data data
916+555-1212 data data data data data data data data data data data data
data data data


Thanks.




--
Don Lincoln



On Friday, June 15, 2012 2:12 AM Lisa Wilke-Thissen wrote:


Hi,


which version of Word?


No macro, but you can choose the "Find" command to select all those
numbers. And then copy and paste them into another document (I would
prefer an Excel sheet):

1. Ctrl + H | Find | More
2. Find what: ^#^#^#+^#^#^#-^#^#^#^#
3. Find in: Main document

All instances will be selected. So you can copy/paste them at once.

In Excel 2010 you can easily remove duplicates:
On the Data tab, in the Data Tools group, click Remove Duplicates.

--
Cheers
Lisa [MS MVP Word]




  #4  
Old October 8th 18, 10:15 PM posted to microsoft.public.word.docmanagement
[email protected]
external usenet poster
 
Posts: 2
Default Extract phone number from word file

Kmttech is right solution for extract your phone numbers from word files. You can try free of cost demo version with 100% secure utility https://www.kmttech.com
  #5  
Old October 8th 18, 10:19 PM posted to microsoft.public.word.docmanagement
[email protected]
external usenet poster
 
Posts: 2
Default Extract phone number from word file

Free of cost demo version software extract phone numbers from word http://www.kmttech.com
  #6  
Old October 22nd 18, 07:49 AM
jondaly jondaly is offline
Junior Member
 
First recorded activity by WordBanter: Oct 2018
Posts: 0
Default

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

I 'm looking for a word macro that will
extract numbers from a word file


which version of Word?

The format of those numbers are ###+###-####,


No macro, but you can choose the "Find" command to select all those
numbers. And then copy and paste them into another document (I would
prefer an Excel sheet):

1. Ctrl + H | Find | More
2. Find what: ^#^#^#+^#^#^#-^#^#^#^#
3. Find in: Main document

All instances will be selected. So you showbox can copy/paste them at once.

In Excel 2010 you can easily remove duplicates:
On the Data tab, in the Data Tools group, click Remove Duplicates.

--
Cheers
Lisa [MS MVP Word]
Choose the "Find" command to select all numbers then copy and paste them into another document
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
user form - format a phone number word 2007 Dcook Microsoft Word Help 2 May 12th 10 11:38 PM
user form - format a phone number word 2007 Dcook Microsoft Word Help 0 May 12th 10 03:31 PM
Word 2007-format a text form field as a phone number Tammy Microsoft Word Help 3 December 15th 09 07:20 PM
Offcie Pro 2007 - extract phone numbers from word and text formats hbscreamer Microsoft Word Help 1 February 21st 08 04:08 PM
phone directory with addresses and phone number from existing fi. Nicky Mailmerge 1 October 11th 06 04:47 AM


All times are GMT +1. The time now is 01:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright ©2004-2018 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.