How to Remove Leading Zeros in Excel

Posted on January 8th, 2016 by wilson

I had the occasion to download a blacklist of IPs. The problem was that this machine generated list padded zeros in front of it. For example, instead of 1.2.3.4 it was listed as 001.002.003.004. I didnt relish having to manually edit all 10,000 IP addresses. So I did research. This post gave a formula to […]

No Comments »
Filed under: Computing, Security

Splunk Notes: Main Index growing

Posted on January 6th, 2016 by wilson

My splunk enterprise shows that the main index is growing much faster than the squid access logs i sent to squid-access-log index. Upon review, it seems that during setup of the splunkforwarder service, i added the entire c:\squid\var\logs folder as a directory to be ‘monitored’ This directive was stored in the default splunk directory/etc/app/splunk_TA_Windows/local/input.conf All […]

No Comments »
Filed under: Big Data