Count the no of records in a file using positional search string

[sujiconstantine]

Hi
I need to count the number of records in a file that starts with the value 'A01'. If this value is found in other parts of the string, it should be ignored.

Can someone help please?

[barnabe0057]

Hi, try this :

Code: Select all

@echo off

set /a number=0

for /f "usebackq delims=" %%A in ("file.txt") do (echo %%A | findstr /b "A01" >nul && set /a number+=1)

echo number of records = %number% 

pause
exit

[sujiconstantine]

thank you

[dbenham]

Ugh - That is a horribly inefficient way to do it. You might not notice with a small file. But a large file will be painfully slow.

If all you want is to print the count to the screen, then

Code: Select all

findstr /b "A01" "file.txt" | find /n /v ""

If you want to capture the value in a variable, then

Code: Select all

for /f %%N in ('findstr /b "A01" "file.txt" ^| find /n /v ""') do set count=%%N

Dave Benham

[barnabe0057]

Thanks for the correction, I still have a few techniques to learn

[sujiconstantine]

thank you for you help dbenham