How to check condition in txt file

[Yogesh123]

Dear Experts,

How to do this,

if token no 5 in abc.txt is LEQ 25, do echo %%i %%j %%k %%l %%m %%n %%o of abc.txt to output.txt

this is what i have tried
cd\
d:
for /f "tokens=5" %%i in (abc.txt) do set LD=%%i
if %LD% LEQ 25 (echo %%i %%j %%k %%l %%m %%n %%o>> output.txt
) else (
echo Noresult found
)
pause

abc.txt has following record,
abc.tre 0 W131738 qwe 16 2009
sfsdf.sdfsdf 0 W131455 qwe 27 2009
fsdf.rty 0 W7F0BCU182 qwe 30 2009
qw.qwe 2 w4059 qwe 15 2009
wsx.rfv 2 W0132017 qwe 12 2009
xdr.cft 0 W0132017 qwe 11 2009
tgb.ikm 2 W0131738 qwe 31 2009
xdr.cft 0 W0132017 qwe 25 2009

Output.txt should have, (records where the 5th coloumn value is LEQ 25 )
abc.tre 0 W131738 qwe 16 2009
qw.qwe 2 w4059 qwe 15 2009
wsx.rfv 2 W0132017 qwe 12 2009
xdr.cft 0 W0132017 qwe 11 2009
xdr.cft 0 W0132017 qwe 25 2009

but i am getting following result in output.txt
%i %j %k %l %m %n %o
pls advise.

[gh0std0g74]

you are missing a bracket of the for loop

[Yogesh123]

Dear gh0std0g74,
are you talking about for bracket,
i have tried by this also , but not working
cd\
d:
for /f "tokens=5" %%i in (abc.txt) do (
set LD=%%i
if %LD% LEQ 25 (echo %%i %%j %%k %%l %%m %%n %%o>> output.txt
) else (
echo Noresult found
)
)
pause

[Salmon Trout]

Fixed your code. The 5th token is %%m so I don't know why you were testing %%i. Also you need to learn about delayed expansion.

Code: [Select]

setlocal enabledelayedexpansion
cd\
d:
for /f "tokens=5" %%i in (abc.txt) do (
set LD=%%m
if !LD! LEQ 25 (
echo %%i %%j %%k %%l %%m %%n %%o>> output.txt
) else (
echo No result found
)
)


[Yogesh123]

Dear Salmon Trout,
seems to be not working properly,
the result i got in output.txt is as follows,
16 %j %k %l %m %n %o
27 %j %k %l %m %n %o
30 %j %k %l %m %n %o
15 %j %k %l %m %n %o
12 %j %k %l %m %n %o
11 %j %k %l %m %n %o
31 %j %k %l %m %n %o
25 %j %k %l %m %n %o

the result in output.txt should be (the output.txt should omit the record, where in the 5th token of abc.txt is greater than 25)
abc.tre 0 W131738 qwe 16 2009
qw.qwe 2 w4059 qwe 15 2009
wsx.rfv 2 W0132017 qwe 12 2009
xdr.cft 0 W0132017 qwe 11 2009
xdr.cft 0 W0132017 qwe 25 2009

[Salmon Trout]

"tokens=1-7"

You want to process tokens %%i to %%o - that makes 7, so "tokens=5" is wrong.

You should be checking these things yourself!

Code: [Select]

setlocal enabledelayedexpansion
cd\
d:
for /f "tokens=1-7" %%i in (abc.txt) do (
set LD=%%m
if !LD! LEQ 25 (
echo %%i %%j %%k %%l %%m %%n %%o>> output.txt
) else (
echo No result found
)
)

[Yogesh123]

Thanx Salmon Trout,
Condition checking part is done,
but values of %%j %%k %%l %%m %%n are not displaying

result of output.txt i got is,
16 %j %k %l %m %n %o
15 %j %k %l %m %n %o
12 %j %k %l %m %n %o
11 %j %k %l %m %n %o

please advise.

[Salmon Trout]

my abc.txt

Code: [Select]

abc.tre 0 W131738 qwe 16 2009
sfsdf.sdfsdf 0 W131455 qwe 27 2009
fsdf.rty 0 W7F0BCU182 qwe 30 2009
qw.qwe 2 w4059 qwe 15 2009
wsx.rfv 2 W0132017 qwe 12 2009
xdr.cft 0 W0132017 qwe 11 2009
tgb.ikm 2 W0131738 qwe 31 2009
xdr.cft 0 W0132017 qwe 25 2009
my batch

Code: [Select]

setlocal enabledelayedexpansion
for /f "tokens=1-7" %%i in (abc.txt) do (
set LD=%%m
if !LD! LEQ 25 (
echo %%i %%j %%k %%l %%m %%n %%o>> output.txt
) else (
echo No result found
)
)
My output.txt

Code: [Select]

abc.tre 0 W131738 qwe 16 2009
qw.qwe 2 w4059 qwe 15 2009
wsx.rfv 2 W0132017 qwe 12 2009
xdr.cft 0 W0132017 qwe 11 2009
xdr.cft 0 W0132017 qwe 25 2009
I advise: check your code carefully! (Do you need glasses?)

[Yogesh123]

Thanks a lot Salmon Trout,
followed ur advise,  , had small break and cleaned my glasses.
its working great.

[billrich]

C:\batch>cat yo.bat

Code: [Select]

@echo off
rem for /f "delims=" %%a in (abc5.txt) do (
rem echo %%a
rem pause
)

setlocal enabledelayedexpansion
for /f "tokens=1-7" %%i in (abc5.txt) do (
        set LD=%%m
        if !LD! LEQ 25 (
                echo %%i %%j %%k %%l %%m %%n %%o
        ) else (
echo.
echo No result found
                echo  !LD! is greater than 25
                echo %%i %%j %%k %%l %%m %%n %%o
echo.
        )
)

)
OUTPUT:

C:\batch>yo.bat
abc.tre 0 W131738 Nov 16 12:00:57 2009
sfsdf.sdfsdf 0 W131455 Nov 16 10:02:11 2009
fsdf.rty 0 W7F0BCU182 Nov 16 11:02:12 2009
qw.qwe 2 w4059 Nov 16 09:05:38 2009

No result found
 26 is greater than 25
wsx.rfv 2 W0132017 Nov 26 05:06:13 2009

xdr.cft 0 W0132017 Nov 16 07:06:33 2009
tgb.ikm 2 W0131738 Nov 16 12:15:01 2009
C:\batch>

[billrich]

C:\batch>cat yo2.bat

Code: [Select]

@echo off
rem for /f "delims=" %%a in (abc5.txt) do (
rem echo %%a
rem pause
)

rem setlocal enabledelayedexpansion
for /f "tokens=1-7" %%i in (abc5.txt) do (
        set LD=%%m
        if %%m LEQ 25 (
                echo %%i %%j %%k %%l %%m %%n %%o
        ) else (
echo.
echo No result found
                echo  %%m is greater than 25
                echo %%i %%j %%k %%l %%m %%n %%o
echo.
        )
)

)
OUTPUT:

C:\batch>yo2.bat
abc.tre 0 W131738 Nov 16 12:00:57 2009
sfsdf.sdfsdf 0 W131455 Nov 16 10:02:11 2009
fsdf.rty 0 W7F0BCU182 Nov 16 11:02:12 2009
qw.qwe 2 w4059 Nov 16 09:05:38 2009

No result found
 26 is greater than 25
wsx.rfv 2 W0132017 Nov 26 05:06:13 2009

xdr.cft 0 W0132017 Nov 16 07:06:33 2009
tgb.ikm 2 W0131738 Nov 16 12:15:01 2009
C:\batch>

[gh0std0g74]

@OP, are you sure this is a foolproof method to check for date just by comparing 1 or 2 token??

[Salmon Trout]

@OP, are you sure this is a foolproof method to check for date just by comparing 1 or 2 token??

He'll tell you in 13 days 

[billrich]

@OP, are you sure this is a foolproof method to check for date just by comparing 1 or 2 token??

There should be no problem as long as the input date is consistent.

i.e.:

The fifth field ( fifth token ) is the day of the month and the default delimiter is a space.

[Salmon Trout]

But 1st December satisfies LEQ 30th November; and I see trouble ahead if the day number has a leading zero. I guess we'll find out in a fortnight.