|
Hello All, I would like to take the following file (180 Pages) and turn it into a true CSV file. I am able to remove the uninteresting characters and insert commas before the port numbers. I then search the document for a comma and do a back space to get the the port number up on the same line as the IP address/host name. My Question is how do I make this macro continue through the whole document?
All Help is appreciated.
BEFORE
* + 144.32.1.10 mvsgw.MyCompany.com |___ 1025 network blackjack * + 144.32.3.254 ncc.MyCompany.com |___ 135 DCE endpoint resolution |___ 139 NETBIOS Session Service |___ 445 Microsoft-DS |___ 1025 network blackjack |___ 5168 TrendMicroNormalServer * + 144.32.4.244 h48mv31.MyCompany.com |___ 135 DCE endpoint resolution |___ 445 Microsoft-DS |___ 2967 Symantec Antivirus * + 144.32.4.245 cw2k.MyCompany.com |___ 135 DCE endpoint resolution |___ 139 NETBIOS Session Service |___ 445 Microsoft-DS |___ 1025 network blackjack |___ 2967 Symantec Antivirus * + 144.32.4.246 certman.MyCompany.com |___ 135 DCE endpoint resolution |___ 139 NETBIOS Session Service |___ 445 Microsoft-DS |___ 1025 network blackjack
AFTER 144.32.1.10 mvsgw.MyCompany.com,1025 network blackjack 144.32.3.254 ncc.MyCompany.com,135 DCE endpoint resolution,139 NETBIOS Session Service,445 Microsoft-DS,1025 network blackjack,5168 TrendMicroNormalServer 144.32.4.244 h48mv31.MyCompany.com,135 DCE endpoint resolution,445 Microsoft-DS,2967 Symantec Antivirus 144.32.4.245 cw2k.MyCompany.com,135 DCE endpoint resolution,139 NETBIOS Session Service,445 Microsoft-DS,1025 network blackjack,2967 Symantec Antivirus 144.32.4.246 certman.MyCompany.com,135 DCE endpoint resolution,139 NETBIOS Session Service,445 Microsoft-DS,1025 network blackjack
Donald Sweat |