I need some assistance.
I'm using RVTools to extract information about all our VC servers.
The networking tab, has a column called "IP Addresses". Problem is, it shows ALL the IP Addresses of the server delimited by commas (IPv6, IPv4, Internal Addresses & External Addresses).
I need Excel to do the following:
1. Remove all IPv6 Addresses
2. divide into two columns, Internal Addresses and External Addresses delimited by commas
3. After each of the previously added column, another column will be added with the count of each address type
So for a server with the following IP addresses: [10.7.0.200,10.23.25.155,10.23.91.56,18.104.22.168,22.214.171.124] I'll end up with four colums:
[10.7.0.200,10.23.35.155,10.23.91.56]  [126.96.36.199,188.8.131.52]