1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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!

submitted by /u/hsmuckley
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#rows.com
#real-time data collaboration
#IP addresses
#duplicate entries
#network
#worksheet
#auto populate
#grep
#template
#search function
#Customer name
#pipes
#addresses
#copy+paste
#repetitive task