Parse an string output in batch

Question

I have a Kaspersky output from an scan by calling avp.com in a batch program. I have this output in a variable named RES, the content of this variable is:

enter image description here

I need to parse this string to get the Total detected value, in the above example is 0. I have tried with the for statement in batch, but not getting the result as expected.

Note:Edited with the anwser of @mbroshi

set KAVDir="C:\Program Files (x86)\Kaspersky Lab\Kaspersky Endpoint Security 10 for Windows\avp.com"
for /f "tokens=3 delims= " %%i in ('%KAVDir% /i0 %1 ^| FINDSTR "Total detected"') 
do 
( 
SET RES=%%i 
ECHO %RES% 
)

The text of the output of an execution of the avp.com program is:

2014-02-26 15:01:58 Scan_Objects$0697         starting   1%         
; --- Settings ---
; Action on detect:     Ask user
; Scan objects:         All objects
; Use iChecker:         Yes
; Use iSwift:           Yes
; Try disinfect:        Yes
; Try delete:           Yes
; Try delete container: No
; Exclude by mask:      No
; Include by mask:      No
; Objects to scan:      
;   "D:\Codigo\Git_Segmail\mail_filters\segmail20\server\service_node_helpers\antivirusscripts\eicar.com.txt"   Enable=Yes  Recursive=No
; ------------------
2014-02-26 15:01:58 D:\Codigo\Git_Segmail\mail_filters\segmail20\server\service_node_helpers\antivirusscripts\eicar.com.txt:Zone.Identifier ok
Progress 50%...
2014-02-26 15:01:58 D:\Codigo\Git_Segmail\mail_filters\segmail20\server\service_node_helpers\antivirusscripts\eicar.com.txt detected    EICAR-Test-File
Progress 50%...
2014-02-26 15:01:58 Scan_Objects$0697         running    50%        
2014-02-26 15:02:00 D:\Codigo\Git_Segmail\mail_filters\segmail20\server\service_node_helpers\antivirusscripts\eicar.com.txt was deleted
2014-02-26 15:02:00 Scan_Objects$0697         completed             
;  --- Statistics ---
;  Current time:    2014-02-26 15:02:00
; Time Start:           2014-02-26 15:01:58
; Time Finish:          2014-02-26 15:02:00
; Completion:           100%
; Processed objects:    2
; Total detected:       1
; Detected exact:       1
; Suspicions:           0
; Treats detected:      1
; Untreated:            0
; Disinfected:          0
; Quarantined:          0
; Deleted:              1
; Skipped:              0
; Archived:             0
; Packed:               0
; Password protected:   0
; Corrupted:            0
; Errors:               0
; Last object:          
;  ------------------

Magoo · Accepted Answer · 2014-02-26 20:33:07Z

3

@ECHO OFF
SETLOCAL
set KAVDir="C:\Program Files (x86)\Kaspersky Lab\Kaspersky Endpoint Security 10 for Windows\avp.com"
FOR /f "eol=#tokens=2delims=:" %%a IN ('%KAVDir% /i0 %1 ^|find "Total detected"') DO SET /a totdet=%%a
ECHO Total detected is %totdet%
GOTO :EOF

Note that findstr "Total detected" will find any lines containing "Total" or "detected", hence the use of FIND (could also have been done with findstr /c:"Total detected"

answered Feb 26, 2014 at 20:33

Magoo

80.8k8 gold badges68 silver badges92 bronze badges

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

3 Comments

mbroshi Over a year ago

Yep--forgot about that /c. More importantly, I forgot the default eol is ;!

yosbel Over a year ago

Thanks both for the reply, this one in particular help me solve the problem, then I knew what was the problem with the other one. Thanks @mbroshi and @Magoo!

yosbel Over a year ago

Note that to this example works fine it is needed to add the call statement before %KAVDir%.

mbroshi · Accepted Answer · 2014-02-26 20:42:31Z

2

You can pipe to FINDSTR to get the line you need:

set KAVDir="C:\Program Files (x86)\Kaspersky Lab\Kaspersky Endpoint Security 10 for Windows\avp.com"
for /f "eol=# tokens=4 delims= " %%i in (
    '%KAVDir% /i0 %1 ^| FINDSTR /C:"Total detected"'
) do (
    set RES=%%i
)

Edit: As pointed out by Magoo, I needed to add a /C to search for the exact string "Total detected" and added a different eol in the for loop, as by default it will skip lines beginning with a ;.

edited Feb 26, 2014 at 20:42

answered Feb 26, 2014 at 19:26

mbroshi

9898 silver badges22 bronze badges

3 Comments

yosbel Over a year ago

Thanks por the reply @mbroshi, I don't know why but the RES value that is setted is an empty string. Should I try something else? Thanks

mbroshi Over a year ago

@yosoy Can you post the actual text of the line to your question? I'm setting the delimiter to space and grabbing the third token in the above script. E.g., perhaps there are tabs in %KAVdir% variable.

yosbel Over a year ago

I have edited the question putting the exact text I have in the .bat file. I added the call statement, but still with no good results. I also put the output of the call statement by calling this one and saving the output to a file.

Collectives™ on Stack Overflow

Parse an string output in batch

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related