Creating Comma Separated Values in Batch Scripting

Question

I have written a piece of code in Batch script which is somewhat like :

( 
    wmic.exe /node:x.x.x.x computersystem get name
    wmic.exe /node:x.x.x.x computersystem get domain 
    wmic.exe /node:x.x.x.x computersystem get manufacturer 
    wmic.exe /node:x.x.x.x computersystem get model 
    wmic.exe /node:x.x.x.x computersystem get username 
    wmic.exe /node:x.x.x.x computersystem get systemtype
) >> file.txt

The contents of file.txt are :

ABC123  
xyz.com  
Hewlett-Packard  
HP xw4400 Workstation  
ABC123\Administrator  
x64-based PC

I want above information to be stored in CSV format as follows :

ABC123 , xyz.com , Hewlett-Packard , HP xw4400 Workstation , ABC123\Administrator , x64-based PC

How can this be achieved?

MC ND · Accepted Answer · 2014-03-27 11:12:53Z

1

@echo off
for /f "skip=2 delims=" %%a in (
    'wmic /node:localhost computersystem get name^,domain^,manufacturer^,model^,username^,systemtype /format:csv'
) do (
    for /f "tokens=2-7 delims=," %%b in ("%%a") do (
        echo(%%e , %%b , %%c , %%d , %%g , %%f
    )
) >> file.txt

In case you doub why the two for commands, the output of the WMIC contains an aditional carriage return character that has to be removed.

answered Mar 27, 2014 at 11:12

MC ND

71.1k8 gold badges95 silver badges136 bronze badges

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

6 Comments

Mandar Shinde Over a year ago

Perfect! What if I wish to add IP address and MAC Address too?

MC ND Over a year ago

@MandarShinde That data is available with wmic nicconfig. But you will need to first determine from which nic you want the data, if ip4 or ip6 or both. The way to get the data is the same that the posted code. Retrieve one set of fields and store them in variables, retrieve the second set and store in variables. Then output the variables content into the output file.

Mandar Shinde Over a year ago

What if I have to execute another wmic command (say, wmic cpu) and append it's output next to the output above mentioned command (wmic computersystem) so that they are seen in the same row?

MC ND Over a year ago

@MandarShinde, the same as above. In the for commands, instead of echoing the data, save the values inside variables. When you have all the required information in variables, then echo %var1%,%var2%,... >> file.txt

Mandar Shinde Over a year ago

Your script mentioned above works absolutely fine. But I, being a novice in Batch Scripting, am not able to understand certain things. First of all, meaning of "tokens=2-7". When I changed it to "tokens=1-6", the output changed. Second thing is, in the echo statement, you used %%e , %%b , %%c , %%d , %%g , %%f. Why not alphabetically %%b , %%c , %%d , %%e , %%f , %%g? (Might be a silly doubt, apologies for that.)

|

Mark Setchell · Accepted Answer · 2014-03-27 10:47:40Z

0

Something like this:

FOR /F %%i IN ('wmic computersystem get name') DO SET N=%%i
FOR /F %%i IN ('wmic computersystem get domain') DO SET D=%%i
echo %N%;%D% > output.csv

answered Mar 27, 2014 at 10:47

Mark Setchell

210k32 gold badges310 silver badges504 bronze badges

5 Comments

Mandar Shinde Over a year ago

Tried this. It is just displaying series of commas in the output file.

Mark Setchell Over a year ago

If you typed it at the console, you need to change %% into %. The way it is written is correct if you save it in a batch file and run it - not for typing in by hand.

Mandar Shinde Over a year ago

No, I typed that in a batch file and executed it.

Mark Setchell Over a year ago

Try copying it and pasting it, rather than typing it.

Mandar Shinde Over a year ago

Same results. Only commas are being displayed.

Collectives™ on Stack Overflow

Creating Comma Separated Values in Batch Scripting

2 Answers 2

6 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related