How do i get a specific line from an output using a batch file?

Question

I have the code below that returns the hostname and IP address of a given server. How can i only have the hostname as the output?

FOR /F %%i in (servers.txt) do FOR /F "skip=3 delims=: tokens=2 usebackq" %%j in (`nslookup %%i`) do @echo %%j >> Devices_With_IP.txt

dbenham · Accepted Answer · 2014-02-24 22:08:48Z

1

Assuming your machine uses English:

FOR /F %%i in (servers.txt) do FOR /F "delims=: tokens=2" %%j in (
  'nslookup %%i ^| find "Name:"'
) do @echo %%j >> Devices_With_IP.txt

answered Feb 24, 2014 at 22:08

dbenham

132k29 gold badges273 silver badges410 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

unclemeat · Accepted Answer · 2014-02-24 23:13:38Z

1

Try using the findstr command on the output of your nslookup to get only the line containing "Name".

FOR /F %%i in (servers.txt) do FOR /F "tokens=2 usebackq delims=: " %%j in (`nslookup %%i ^| findstr Name`) do @echo %%j >> Devices_With_IP.txt

Note that I also rearranged the /F conditions in the second loop in order to include space as a deliminator, this removes the leading spaces before the output.

Using the find command instead of findstr -

FOR /F %%i in (servers.txt) do FOR /F "tokens=2 usebackq delims=: " %%j in (`nslookup %%i ^| find "Name"`) do @echo %%j >> Devices_With_IP.txt

Just realized that using find instead of findstr makes this (almost) exactly the same as dbenham's answer.

edited Feb 24, 2014 at 23:13

answered Feb 24, 2014 at 22:08

unclemeat

5,2075 gold badges32 silver badges55 bronze badges

5 Comments

PeanutsMonkey Over a year ago

No output is generated.

unclemeat Over a year ago

@PeanutsMonkey, I just added the redirect to your Devices_With_IP.txt, before it only outputted to the terminal. Was that the problem?

PeanutsMonkey Over a year ago

Nope. I had it as well. No results are displayed nor is a file generated.

unclemeat Over a year ago

@PeanutsMonkey it works for me. What version of Windows are you running?

PeanutsMonkey Over a year ago

I'm running Windows 7. I do have access to the findstr command. Ran it against the dir command and it works just fine.

Collectives™ on Stack Overflow

How do i get a specific line from an output using a batch file?

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related