I couldn't think how to phrase a search on this one so I'll ask it directly.
I'm doing IP address scans and I get back varied results. They always come in the format like this:
100.100.100.100
22/tcp open
80/tcp open
200.200.200.200
443/tcp open
And so on. The address starts on the first row followed by one to four rows of port numbers.
I would like to have them transposed though, in a format of the address followed by the ports:
111.111.111.111 22/tcp open 80/tcp open
222.222.222.222 80/tcp open
This would make it easier to search. Can you tell me if I'm missing something simple or if this is a complex task?
My list can be 500+ rows so manually scanning them gets grueling.
Hi kidfury,
Welcome to the forum.
In your query, you have 100.100.100.100 but in your answer set you have got 111.11.111.111.... not able to understand this. please explain little more. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
The number of ports could vary from 1 IP to the other rite?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Correct, I could get different ports for each address. Most of the time I only get one but often will get three lines below the IP address
Sorry about the format of the IP addresses. They will all be different and varied in the format of XXX.XXX.XXX.XXX
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks