Computer Hope

Microsoft => Microsoft DOS => Topic started by: joejames786 on October 24, 2017, 08:09:58 AM

Title: file sorting by size
Post by: joejames786 on October 24, 2017, 08:09:58 AM

hi

Iam a new to batch programming and would like to seek you help.

I have 1000's of log files (.txt) in hundreds of folders varying in size from 2kb to 30mb
my request is
 a batch file to sort files as per their sizes and move them creating a new folder
10kb
20kb
50kb
500kb
and so on ..
can this be done if so please help..

thanx

Title: Re: file sorting by size
Post by: Squashman on October 27, 2017, 01:41:10 PM

You can get a list of files in a directory like this.

Code: [Select]

FOR %%G IN (*.txt) DO (
    echo %%G
)
Now the really cool thing about the FOR command is that it has modifiers for the FOR variable to get different attributes from the file.  This is listed in the help for the FOR command.
You can read the help for the FOR command by typing this at a cmd prompt.

Code: [Select]

for /?The very last section of the help refers to the modifiers.

Code: [Select]

In addition, substitution of FOR variable references has been enhanced.
You can now use the following optional syntax:

    %~I         - expands %I removing any surrounding quotes (")
    %~fI        - expands %I to a fully qualified path name
    %~dI        - expands %I to a drive letter only
    %~pI        - expands %I to a path only
    %~nI        - expands %I to a file name only
    %~xI        - expands %I to a file extension only
    %~sI        - expanded path contains short names only
    %~aI        - expands %I to file attributes of file
    %~tI        - expands %I to date/time of file
    %~zI        - expands %I to size of file
    %~$PATH:I   - searches the directories listed in the PATH
                   environment variable and expands %I to the
                   fully qualified name of the first one found.
                   If the environment variable name is not
                   defined or the file is not found by the
                   search, then this modifier expands to the
                   empty string

The modifiers can be combined to get compound results:

    %~dpI       - expands %I to a drive letter and path only
    %~nxI       - expands %I to a file name and extension only
    %~fsI       - expands %I to a full path name with short names only
    %~dp$PATH:I - searches the directories listed in the PATH
                   environment variable for %I and expands to the
                   drive letter and path of the first one found.
    %~ftzaI     - expands %I to a DIR like output line

In the above examples %I and PATH can be replaced by other valid
values.  The %~ syntax is terminated by a valid FOR variable name.
Picking upper case variable names like %I makes it more readable and
avoids confusion with the modifiers, which are not case sensitive.
So by using the ~z modifier you can get the the size of the file in bytes.

Code: [Select]

FOR %%G IN (*.txt) DO (
    echo Filename is: %%G
    echo File Size is: %%~zG
)