{"id":483,"date":"2013-12-03T01:12:14","date_gmt":"2013-12-03T01:12:14","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=483"},"modified":"2014-11-22T14:32:53","modified_gmt":"2014-11-22T14:32:53","slug":"grep-like-command-in-windows","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=483","title":{"rendered":"Grep like command in Windows?"},"content":{"rendered":"

In Linux & Unix, I find that I use the grep command to filter the information by different utilities that returns more then a screen full of information.\u00a0 For example using netstat, normally I want to view only the connections to a certain port numbers. Below is an example in Linux.<\/p>\n

\"Linux<\/p>\n

I need to do the same type of filtering in the Windows Command Prompt.\u00a0 Using the Windows “find<\/a>” command, I am able to filter the results with something similar to the grep command in Linux\/Unix.\u00a0 In the example below, I want to see only those lines from the netstat utility that have the port number 1433.\u00a0 I am able to pipe the results to the “find” command for the string 1433.<\/p>\n

An important difference with the “find” command is that I must have my filtering string in double quotes. Example: netstat -an | find “1433”<\/em>
\n<\/strong><\/p>\n

\"Windows<\/a>

netstat -an | find “1433”<\/p><\/div>\n

The find command does not have all the functionality of the grep command.\u00a0 However 90% of what I use in the grep command, I am able to accomplish with the “find” command.\u00a0 For example,\u00a0 I am able to filter the utility “tasklist” to return only the information on the services or processes that I am interested in seeing.<\/p>\n

\"Windows<\/a>

tasklist | find “sql”<\/p><\/div>\n

For the Powershell Console window:<\/p>\n

\"findstr\"<\/a>

netstat -an | findstr “1433”<\/p><\/div>\n

In the PowerShell Console window, the find command will not work.\u00a0 The “findstr” does the same thing as the “find” in the command prompt.<\/p>\n","protected":false},"excerpt":{"rendered":"

In Linux & Unix, I find that I use the grep command to filter the information by different utilities that returns more then a screen full of information.\u00a0 For example … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":486,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,10],"tags":[],"class_list":["post-483","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","category-windows"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/483"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=483"}],"version-history":[{"count":23,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/483\/revisions"}],"predecessor-version":[{"id":825,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/483\/revisions\/825"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/486"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}