String maniupulation in batch script

Question

I've got a script to retrieve PowerPath license information from arround 2k servers, I've automated this with simple script:

for /F %%A in (server_list.txt) do (
echo %%A >> PP_license.txt
psexec \\%%A powermt check_registration | find "Key" >> PP_license.txt
)

But I'm not happy with this output file, which now looks like this:

server1
Key XXXX-XXXX
server2
Key YYYY-YYYY

Is it possible to manipulate this to get output like:

server1 XXXX-XXXX
server2 YYYY-YYYY

?

If not then I'll try do this in PowerShell.

Aacini · Accepted Answer · 2013-12-12 14:28:13Z

2

for /F %%A in (server_list.txt) do (
    for /F "tokens=1*" %%B in ('psexec \\%%A powermt check_registration ^| find "Key" ') do (
        echo %%A %%C>> PP_license.txt
    )
)

answered Dec 12, 2013 at 14:28

Aacini

67.7k12 gold badges74 silver badges114 bronze badges

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

Comments

Monacraft · Accepted Answer · 2013-12-12 14:06:32Z

1

Try this

ren PP_license.txt PP_license.tmp
3<PP_license.tmp (
:loop
set /p srv=<&3
set /p key=<&3
if "%srv%"=="" goto :end
<nul set /p=%srv% >> PP_license.txt
for /f "tokens=2" %%a in "%key%" do set key=%%a
Echo %key% >> PP_license.txt
goto :loop
:end
)

And that should do exactly what you want.

Mona

answered Dec 12, 2013 at 14:06

Monacraft

6,6502 gold badges20 silver badges30 bronze badges

Comments

npocmaka · Accepted Answer · 2013-12-12 14:43:47Z

1

for /F %%A in (server_list.txt) do (
    (echo|set /p"= %%A ")>> PP_license.txt
    for /f "tokens=* delims=" %%x in ('psexec \\%%A powermt check_registration ^| find "Key" ') do (
        (echo %%x)>>PP_license.txt
    )
)

edited Dec 12, 2013 at 14:43

answered Dec 12, 2013 at 13:59

npocmaka

57.8k19 gold badges162 silver badges199 bronze badges

3 Comments

beria-pl Over a year ago

Ok, that almost works :) But now the output is like this: server1 key XXXX-XXXXserver2 key YYYY-YYYYserver3 key ZZZZ-ZZZZ

beria-pl Over a year ago

This comments give bad format ;) So now I have: server1 (newline) key XXXX server2 (newline) key YYYY, What I want to get is: server1 xxxx (newline) server2 yyyy ...

npocmaka Over a year ago

Despite you have your answer I've edited mine again.Now it should work.

Collectives™ on Stack Overflow

String maniupulation in batch script

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related