ansaurus

Question

How to filter txt file by string with using batch

Answer 1

A:

Write a C application. Batch is unnecessarily kludgy and probably can't even do this kind of stream manipulation.

Delan Azabani 2010-05-26 12:38:32

HIYes you are right = should be 4 instead of 9 - and first of all thank you for this solution - it works perfectly . now the only problem which left me is to delay the execute of this command . Because at first first script creates report.txt and next filters it as you wrote . I don't know how to combine them because filter searches for file which doesn't exist yet - it needs about 3-5 s and I have no idea how to delay it - I tried "PING -n 4 127.0.0.1>nul " but it doesn't pause .

Antediluvian 2010-05-26 15:37:05

Answer 2

+1 A:

Not sure where you got the figure of 9 for the Intra_CLIENT_License (souldn't it be 4?), but this script will print out the free licences for those two product codes:

@echo off
setlocal enableextensions enabledelayedexpansion
for /f "tokens=1,3" %%a in ('type infile.txt') do (
    if "x%%a"=="xSingleSite_License" (
        echo %%a %%b
    )
    if "x%%a"=="xIntra_CLIENT_License" (
        echo %%a %%b
    )
)
endlocal

I basically cut and pasted your transcript into the infile.txt file and ran this script to get:

SingleSite_License 3
Intra_CLIENT_License 4

(you can replace type infile.txt with whatever command you need to generate that output).

Breakdown:

The setlocal just sets up cmd.exe to allow extensions and delayed expansion of environment variables. All my scripts start with this since it's so useful.

The for loop basically processes one line at a time, grabbing tokens 1 and 3 (a and b) from each.

Then it's a simple matter of checking a for the required licence values and, if it matches, outputting that along with b.

paxdiablo 2010-05-26 12:51:34

Is that plain batch?

Jens Björnhager 2010-05-26 12:54:50

@Jens, Yes, it was done on XP so should work on all supported versions of Windows. Don't try to backport it to Windows 3.11 :-) Batch has come a long way since the brain-dead days of MSDOS 2.11 - it's still no match for UNIX shells but it's not _too_ bad.

paxdiablo 2010-05-26 12:59:30

Well, a +1 from me then :)

Jens Björnhager 2010-05-26 13:03:04

HI Yes you are right = should be 4 instead of 9 - and first of all thank you for this solution - it works perfectly . now the only problem which left me is to delay the execute of this command . Because at first first script creates report.txt and next filters it as you wrote . I don't know how to combine them because filter searches for file which doesn't exist yet - it needs about 3-5 s and I have no idea how to delay it - I tried "PING -n 4 127.0.0.1>nul " but it doesn't pause

Antediluvian 2010-05-26 15:38:02

@Ante, that ping command _should_ wait 3 seconds. Leave off the `>nul` bit and tell me what the output is.

paxdiablo 2010-05-27 01:35:26

OK everything seems to ok now . THANK YOU very much for this tip !! best regards

Antediluvian 2010-05-27 15:47:55

Answer 3

A:

Download UnxUtils and use the Unix stream processors. Might be possible to do with Powershell too.

Jens Björnhager 2010-05-26 12:52:18

ansaurus

tags:

views:

answers:

How to filter txt file by string with using batch

related questions