How to count no of lines in text file and store the value into a variable using batch script

Question

I want to count the no of lines in a text file and then the value has to be stored into a environment variable  The command to count the no of lines is   findstr  R  N     file txt   find  C       I refered the question How to store the result of a command expression in a variable using bat scripts   Then I tried    set cmd  findstr  R  N     file txt   find  C         I am getting the error message    FIND  Parameter format not correct   How could i get rid of this error

User · Answer

I found this solution to work best for creating a log file that maintains itself:

setlocal enabledelayedexpansion
SET /A maxlines= 10
set "cmd=findstr /R /N "^^" "filename.txt" | find /C ":""
 for /f %%a in ('!cmd!') do set linecount=%%a
GOTO NEXT

:NEXT 
 FOR /F %%A IN ("filename.txt") DO ( 
  IF %linecount% GEQ %maxlines% GOTO ExitLoop
  echo %clientname% %Date% %Time% >> "filename.txt")
 EXIT

:ExitLoop
 echo %clientname% %Date% %Time% > "filename.txt"
 EXIT

Environmental variables included are %clientname% the computername of the remote client %Date% is the current date and %Time% the current time. :NEXT is called after getting the number of lines in the file. If the file line count is greater than the %maxlines% variable it goes to the :EXITLOOP where it overwrites the file, creating a new one with the first line of information. if it is less than the %maxlines% variable it simply adds the line to the current file.

User · Answer

Try this    Echo off Set  File file txt Set  a  Lines 0 For  f   j in   Find     v  c   lt    File    Do Set  a  Lines   j Echo   File  has   Lines  lines    It eliminates the extra FindStr and doesn t need expansion     - edited to use ChrisJJ s redirect suggestion  Removal of the TYPE command makes it three times faster

User · Answer

for  f  usebackq   A in   TYPE c  temp file txt    find  v  c       do set numlines  A   in a batch file  use   A instead of  A

User · Answer

I usually use something more like this          for  f    a in    file   do  set  a Lines  1

User · Answer

The perfect solution is   FOR  F   i IN   TYPE  Text file txt     FIND  C  V      DO SET Lines   i

User · Answer

In the below code  the variable name are SalaryCount and TaxCount   ECHO OFF     echo Process started  please wait        for  f   C in   Find  V  C      lt   D  Trial Salary txt    do set SalaryCount   C     echo Salary  SalaryCount  for  f   C in   Find  V  C      lt   D  Trial Tax txt    do set TaxCount   C echo Tax  TaxCount    Now if you need to output these values to a csv file  you could use the below code    ECHO OFF cd  D  CSVOutputPath   echo Process started  please wait    echo FILENAME FILECOUNT gt  SUMMARY csv for  f   C in   Find  V  C      lt   D  Trial Salary txt    do set Count   C echo Salary  Count  gt  gt  SUMMARY csv for  f   C in   Find  V  C      lt   D  Trial Tax txt    do set Count   C echo Tax  Count  gt  gt  SUMMARY csv   The  gt  will overwrite the existing content of the file and the  gt  gt  will append the new data to existing data  The CSV will be generated in D  CSVOutputPath

User · Answer

The  countLines subroutine below accepts two parameters  a variable name  and a filename  The number of lines in the file are counted  the result is stored in the variable  and the result is passed back to the main program   The code has the following features    Reads files with Windows or Unix line endings  Handles Unicode as well as ANSI ASCII text files  Copes with extremely long lines  Isn   t fazed by the null character  Raises an error on reading an empty file  Counts beyond the Batch max int limit of  31 2 -1     echo off  amp  setLocal enableExtensions disableDelayedExpansion  call  countLines noOfLines    1            gt  amp 2 echo file    nx1  is empty  amp  goto end      cond exec    echo file    nx1  has  noOfLines  line s    end - exit program with appropriate errorLevel endLocal  amp  goto  EOF   countLines result    file      counts the number of lines in a file setLocal disableDelayedExpansion  set  lc 0   amp  call   for  f  delims      N in        cmd  d  a  c type    2      amp    lt nul set  p                2  gt nul findStr  n       amp   amp  echo             findStr  blv 1     2  gt nul findStr  lnxc        do  set  lc   N   amp  call      for  f     endlocal  amp  set   1  lc   exit  b  errorLevel     countLines     I know it looks hideous  but it covers most edge-cases and is surprisingly fast

User · Answer

Tony  You can even get rid of the type  file  command   for  f  tokens 2 delims      a in   find  c  v      file    do set  a  Lines   a   For long files this should be even quicker

User · Answer

You could use the FOR  F loop  to assign the output to a variable     I use the cmd-variable  so it s not neccessary to escape the pipe or other characters in the cmd-string  as the delayed expansion passes the string  unchanged  to the FOR-Loop    echo off cls setlocal EnableDelayedExpansion set  cmd findstr  R  N      file txt   find  C       for  f   a in    cmd    do set number   a echo  number

User · Answer

There is a much simpler way than all of these other methods   find  v  c    filename ext   Holdover from the legacy MS-DOS days  apparently   More info here  https   devblogs microsoft com oldnewthing 20110825-00  p 9803  Example use   adb shell pm list packages   find  v  c      If your android device is connected to your PC and you have the android SDK on your path  this prints out the number of apps installed on your device

User · Answer

One nice surprise is for one who has git bash on his windows  just plain old linux wc -l  lt filename gt  will works for you there

User · Answer

You can also mark with a wildcard symbol   to facilitate group files to count   Z  SQLData gt find  c  v    FR OP133 OCCURENCES COUNT PER DOCUMENTS   txt   Result  ---------- FR OP133 OCCURENCES COUNT PER DOCUMENTS AVIFRS01 V1 TXT  2041  ---------- FR OP133 OCCURENCES COUNT PER DOCUMENTS AVIOST00 V1 TXT  315938  ---------- FR OP133 OCCURENCES COUNT PER DOCUMENTS AVIFRS00 V1 TXT  0  ---------- FR OP133 OCCURENCES COUNT PER DOCUMENTS CNTPTF00 V1 TXT  277

User · Answer

You can pipe the output of type into find inside the in      clause of a for  f loop   for  f   A in        type    dpf1     find  c  v       do set  lineCount   A    But the pipe starts a subshell  which slows things down   Or  you could redirect input from the file into find like so   for  f   A in        find  c  v      lt     dpf1     do set  lineCount   A    But this approach will give you an answer 1 less than the actual number of lines if the file ends with one or more blank lines  as teased out by the late foxidrive in counting lines in a file   And then again  you could always try   find  c  v    example txt   The trouble is  the output from the above command looks like this   ---------- EXAMPLE TXT  511   You could split the string on the colon to get the count  but there might be more than one colon if the filename had a full path   Here   s my take on that problem   for  f  delims     A in        find  c  v       1     do for   B in    A  do set  lineCount   B    This will always store the count in the variable   Just one last little problem    find treats null characters as newlines  So if sneaky nulls crept into your text file  or if you want to count the lines in a Unicode file  this answer isn   t for you

User · Answer

Inspired by the previous posts  a shorter way of doing so   CMD exe C   gt FINDSTR  R  N        file txt   FIND  C       The number of lines  Try  it  It works in my console   EDITED    the     sign removed   FINDSTR  R  N       file txt   FIND  C         reduces the number by 1 because it is accepting the first row as Field name and then counting the number of rows

User · Answer

Just   c   gt  for  r  f in    java  do  type  f     find  c  v      Font  https   superuser com questions 959036 what-is-the-windows-equivalent-of-wc-l

User · Answer

You don t need to use find    echo off set  a counter 0 for  f   a in  filename  do set  a counter  1 echo Number of lines   counter    This iterates all lines in the file and increases the counter variable by 1 for each line

[windows] How to count no of lines in text file and store the value into a variable using batch script?

Examples related to windows

Examples related to batch-file

Examples related to cmd