Reply
 
Thread Tools Display Modes
  #1   Report Post  
Don Lincoln Don Lincoln is offline
Junior Member
 
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.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Lisa Wilke-Thissen Lisa Wilke-Thissen is offline
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   Report Post  
Posted to microsoft.public.word.docmanagement
Annie Calvert Annie Calvert is offline
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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] kaven895@gmail.com is offline
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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] kaven895@gmail.com is offline
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   Report Post  
jondaly jondaly is offline
Junior Member
 
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
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
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 09:54 AM.

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"