Extract phone number from word file

donlincolnmsof · #1 06-16-2012, 01:09 PM

Hello Paul

Thanks for the Macro

It worked great.

I had another file and it’s pretty much the same type of thing, but the beginning and ending codes are different.

Can you tweak the code for the below data.

The records begins as rfn= and ends with rph=

Sample record

rfn=Michael;fzp=95070;fst=CA;qn=;fln=;fph=;rst=CA; rzp=95070;lt=R;fad=15160+xy+zat+tlm;rln=dffdsfdsfs fd;rph=408+555-1212

rfn=Kim;fzp=84569;fst=CA;qn=;fln=;fph=;rst=CA;rzp= 84569;lt=R;fad=2660+sdfdf+dsf;rln=Jang;rph=508+555-1212

Below is the dummy data

rfn=Michael;fzp=95070;fst=CA;qn=;fln=;fph=;rst=CA; rzp=95070;lt=R;fad=15160+xy+zat+tlm;rln=dffdsfdsfs fd;rph=408+555-1212;rad=2343+sfdsf+dfsfsf;ord=232231701404?'
var tile = window.dfp_tile_count = window.dfp_tile_count ? ++window.dfp_tile_count : 1
url = url
.replace(/;ord=/, ";bt=" + rsi_data + ";ord=")
.replace(/;tile=\d*;/, ";tile=" + tile + ";")
document.write('\x3Cscript type="text/javascript" src="' + url + '" >\x3C/script>')
})()
</script>

</div>

<div class="ad ad_720x300 ad_under">
<script type="text/javascript">
(function () {
var dfd = 'dfadfadfada adsfadfa afadfafasd adfadffadf asdfa da adfafas
rfn=Michael;fzp=95070;fst=CA;qn=;fln=;fph=;rst=CA; rzp=95070;lt=R;fad=15160+xy+zat+tlm;rln=dffdsfdsfs fd;rph=408+555-1212;rad=2343+sfdsf+dfsfsf;ord=232231701404?'
var tile = window.dfp_tile_count = window.dfp_tile_count ? ++window.dfp_tile_count : 1
url = url
.replace(/;ord=/, ";bt=" + rsi_data + ";ord=")
.replace(/;tile=\d*;/, ";tile=" + tile + ";")
document.write('\x3Cscript type="text/javascript" src="' + url + '" >\x3C/script>')
})()
</script>
</div>
<div class="ad ad_970x1 ad_">
<script type="text/javascript">
(function () {
var url =
'fadsffafdf/N6794/adj/sfdsfs;sz=1x1;tile=2;pos=left;sid=wp.us;pgid=addre ss.results;fct=Saratoga;exact=0;xp=E;ffn=;rct=Saog a;rfn=Michael;fzp=12345;fst=CA;qn=;fln=;fph=;rst=CA; rzp=12345;lt=R;fad=15160+sdfd+dsfsdf+sfd;rln=sfdsf ;rph=408+555-1212;rad=25160+sfsdf+ssdfsd;ord=842231701404?'
var tile = window.dfp_tile_count = window.dfp_tile_count ? ++window.dfp_tile_count : 1
url = url
.replace(/;ord=/, ";bt=" + rsi_data + ";ord=")
.replace(/;tile=\d*;/, ";tile=" + tile + ";")
document.write('\x3Cscript type="text/javascript" src="' + url + '" >\x3C/script>')
})()
</script>
</div>

<div id="right">
<div class="ad ad_160x600-300x250-300x600 ad_top">
<script type="text/javascript">
(function () {
var url = 'sdfdfadfsfresults;sz=720x300;tile=11;pos=over;sid =wp.us;pgid=address.results;fct=meilroy;exact=0;xp =E;ffn=;rct=meilroy;rfn=Kim;fzp=84569;fst=CA;qn=;fln=;fph=;rst=CA;rzp= 84569;lt=R;fad=2660+sdfdf+dsf;rln=Jang;rph=508+555-1212;rad=2660+sdfdsf+sdf;ord=7174278076361?'

Really appreciate your help

Thanks. !!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract Video from .ppsx file	designer	PowerPoint	1	10-14-2011 08:00 AM
Phone number formatting	Mark Micallef	Outlook	1	08-04-2010 02:38 PM
Can I Extract a Page from Word and Make a New DOCX File?	tatihulot	Word	1	06-20-2010 11:38 PM
in WORD, how do i type a 9-digit phone number "xxxxxxxxx" and have it automatically..	jay8962	Word	0	04-08-2010 11:08 AM
automatically extract footnotes into new file and apply character format to footnote	hrdwa	Word	0	02-27-2010 03:16 AM