Complete Macro noob here...
I am working with a very large data set (5,000+ rows, 57 columns) of web server logs. These logs contain a great deal of noise I need cleaned out. The best column to do this from would be the Destination IP addresses. There are over 250 unique addresses. I need to strip out 137 unique addresses and the entire row associated with each to isolate specific browsing behavior. I figured a vlookup from another sheet would work. But I'm not positive.
The format of this column is as follows:
[TABLE="width: 200"]
<tbody>[TR]
[TD]DestinationIP[/TD]
[/TR]
[TR]
[TD]DestIP="111.222.133.44"[/TD]
[/TR]
[TR]
[TD]DestIP="33.44.66.77"[/TD]
[/TR]
[TR]
[TD]DestIP="125.89.143.23"[/TD]
[/TR]
[TR]
[TD]DestIP="76.945.34.87"[/TD]
[/TR]
[TR]
[TD]DestIP="45.347.33.89"[/TD]
[/TR]
[TR]
[TD]DestIP="44.3.22.454"[/TD]
[/TR]
[TR]
[TD]DestIP="130.79.142.56"[/TD]
[/TR]
[TR]
[TD]DestIP="87.56.23.17"[/TD]
[/TR]
[TR]
[TD]DestIP="52.34.576.34"[/TD]
[/TR]
[TR]
[TD]DestIP="53.55.123.45"[/TD]
[/TR]
</tbody>[/TABLE]
(Disclaimer: These are random made up IPs, most of which are not in valid format to protect privacy).
I am working with a very large data set (5,000+ rows, 57 columns) of web server logs. These logs contain a great deal of noise I need cleaned out. The best column to do this from would be the Destination IP addresses. There are over 250 unique addresses. I need to strip out 137 unique addresses and the entire row associated with each to isolate specific browsing behavior. I figured a vlookup from another sheet would work. But I'm not positive.
The format of this column is as follows:
[TABLE="width: 200"]
<tbody>[TR]
[TD]DestinationIP[/TD]
[/TR]
[TR]
[TD]DestIP="111.222.133.44"[/TD]
[/TR]
[TR]
[TD]DestIP="33.44.66.77"[/TD]
[/TR]
[TR]
[TD]DestIP="125.89.143.23"[/TD]
[/TR]
[TR]
[TD]DestIP="76.945.34.87"[/TD]
[/TR]
[TR]
[TD]DestIP="45.347.33.89"[/TD]
[/TR]
[TR]
[TD]DestIP="44.3.22.454"[/TD]
[/TR]
[TR]
[TD]DestIP="130.79.142.56"[/TD]
[/TR]
[TR]
[TD]DestIP="87.56.23.17"[/TD]
[/TR]
[TR]
[TD]DestIP="52.34.576.34"[/TD]
[/TR]
[TR]
[TD]DestIP="53.55.123.45"[/TD]
[/TR]
</tbody>[/TABLE]
(Disclaimer: These are random made up IPs, most of which are not in valid format to protect privacy).