Home > Data Entry, Programming > Excel Easy Part 2

Excel Easy Part 2

December 2nd, 2009

Hi

attached you can find 2 txt files

project1.txt:

the first part of the txt file is HTML

<option selected value=”http://serve.21nova.com/promoRedirect?member=ronco&campaign=DEFAULT&channel=DEFAULT&zone=852947837&lp=835384483″>21 Nova</option>

The second part are names plus links

21 Nova
http://serve.21nova.com/promoRedirect?member=ronco&campaign=DEFAULT&channel=DEFAULT&zone=852947837&lp=835384483
32 Red
http://www.32italia.com/?BTag=32RedBanAff56211
50 Stars Casino
http://banner.50starscasino.com/cgi-bin/redir.cgi?id=N&member=21000000&profile=64427
7 Sultans
http://www.7sultans.me/freetime/btag-ad260914/
….
….

What I need is an excel file (with every row a single entry), or also a txt file (better), looking like this

<option selected value=”http://serve.21nova.com/promoRedirect?member=ronco&campaign=DEFAULT&channel=DEFAULT&zone=852947837&lp=835384483″>21 Nova</option>
<option selected value=”http://www.32italia.com/?BTag=32RedBanAff56211″>32 Red</option>
<option value=”http://banner.50starscasino.com/cgi-bin/redir.cgi?id=N&member=21000000&profile=64427″>50 Stars Casino</option>
<option value=”http://www.7sultans.me/freetime/btag-ad260914/”>7 Sultans</option>
…..
….
….

With all the links in the txt file attached

project2.txt

A bit more complicated

the first part of the txt file is HTML

<option selected value=”http://serve.21nova.com/promoRedirect?member=ronco&campaign=DEFAULT&channel=DEFAULT&zone=852947837&lp=835384483″>21 Nova</option>

The second part are HTML looking like this

<tr class=”sectiontableentry1″>
<td width=”100″ height=”20″ align=”center”>


Excel Easy Part 2

Comments are closed.
Bear