Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

How to properly parse this nmap gnmap file?

I have a file like that:


Host: ( Status: Up
Host: ( Ports: 21/open/tcp//ftp//Super FTP 1.0/, 80/open/tcp//http//thttpd/, 443/open/tcp//ssl|http//thttpd/, 8000/open/tcp//http//thttpd/, 9500/open/tcp//ismserver?/// Ignored State: filtered (986)
Host: ( Status: Up
Host: ( Ports: 80/open/tcp//http//Microsoft IIS httpd 1.0/, 135/open/tcp//msrpc//Microsoft Windows RPC/, 139/open/tcp//netbios-ssn//Microsoft Windows netbios-ssn/ Ignored State: filtered (989)
Host: ( Status: Up
Host: ( Ports: 21/open/tcp//ftp//Omega FTP/, 9500/open/tcp//ismserver?/// Ignored State: filtered (989)


I want to parse it in PBI in a way that I will have a table with IP, Hostname, port, status, type, serivce. So, in this example I would have something like:,, 21, open, ftp, Super FTP 1.0,, 80, open, http, httpd,, 80, open, http, Microsoft IIS httpd 1.0

And so on...


Is there a way?

Community Support
Community Support

Hi JChris,


So your requirement is to clean your data in file, right?


On way is to use Split Column, click Query Editor-> Transform-> Split Column by custom delimiter "\\" then delete useless columns.


The second way is to use R script in Power BI, you can use function like Split() with Regular expression in it to clean your data.



Jimmy Tao

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors