script to process a list of ip addresses from a txt file and then confirm whether they are accessible or responding IPs within a xlsx file

Asked May 31 '22 at 22:10

Active Jun 01 '22 at 02:32

Viewed 194 times

I would like to be able to python script to process a list of IP addresses from a txt file and then confirm whether they are accessible or responding IP Addresses within a excel file.

I have seen the following, which I have used as a base but it doesn't seem to work or work as I would expect;

https://www.geeksforgeeks.org/extract-ip-address-from-file-using-python/

I was going somewhere along the lines of;

import re 
import csv 
f = open('C:/Users/dir/dir/iplogs.txt', 'r') #Text file with many ip address 
o = f.read() 
ip1 = re.findall( r"\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}", o ) 
hosts = ip1 
for host in hosts:

However then I couldn't quite figure out how to manage this from here.

edited Jun 01 '22 at 02:32

Funlamb

asked May 31 '22 at 22:10

Benjamin Hirst

Do you have to do this in Python? This is exactly what the `nmap` tool is for. – Barmar May 31 '22 at 22:12
So you're asking how to test whether an IP responds? That has nothing to do with regular expressions or exporting to CSV. – Barmar May 31 '22 at 22:14
how might you suggest i do this? well i would like the end out put exporting to either csv or xlsx? – Benjamin Hirst May 31 '22 at 22:39
You could use the [`python-nmap`](https://pypi.org/project/python-nmap/) library. – Barmar May 31 '22 at 22:40
Exporting to CSV is simple, use the built-in `csv` module. There are dozens of tutorials on this. – Barmar May 31 '22 at 22:40

script to process a list of ip addresses from a txt file and then confirm whether they are accessible or responding IPs within a xlsx file

0 Answers0