Excel to CLI for repetitive task
Hey! I work in networking and have been tasked with checking 100's of IP addresses for duplicate entries across an entire network, currently everyone is copy+pasting the IPs to search into a template that looks like the below:
grep -E -e "Customer name|X.X.X.X|X.X.X.X|X.X.X.X" *.net*
I need some recommendations on how to create a worksheet that can auto populate the above template, X's are in place of addresses. The final string will be about 3-4 times as long as the section above and the pipes (|) between each IP block are required for the search function to work properly. As a lot of the addresses exist in the same blocks most entries will run in sequence and be adding 1 to the final number on the previous entry, example 'Customer name| 1.1.1.1|1.1.1.2|1.1.1.3'.
I'd appreciate any help with this, I'm not an excel wizz and really want to try and make this less laborious than it currently is, freeing up time for other tasks ... massive thanks in advance!
[link] [comments]
Want to read more?
Check out the full article on the original site