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. !!