I have a program that lists hostnames and IPs. Some hostnames have multiple IPs assigned to them. When I download the IP column .csv, it lists as such:
192.168.xx.xx
"192.168.xx.xx, 192.168.xx.xx"
192.168.xx.xx
I am putting the contents of this .csv file into a VI file. What I would like to do is figure out how to script it so that the lines with 2 IPs (with the " " and ,) move one of the IPs to a new line and remove all of the " " and , so that I can easily run this through a Powershell script to ping each and get their up/down status.
Goal would be to get this file:
192.xx.xx
192.xx.xx
192.xx.xx
192.xx.xx
Any suggestions? Thanks so much!