This is in reference to another question: How do I use robocopy to list all files over a certain size recursively?

I would like to parse output of a command (or cat a log file) and find a string value, convert it to an integer and then see if that integer value is greater than a given integer.

For instance, given the line:

      *EXTRA File          78223    C:\_Google.Enterprise.Contract.2010-06-01.pdf

I'd like to compare '78223' to '10485760'. Is this possible with grep or sed?

Thanks!

link|improve this question

60% accept rate
2  
You probably awk, or a scripting language for numerical comparisons. – Zoredache Sep 2 '11 at 19:48
Thanks, I'll look into using awk. – mbrownnyc Sep 2 '11 at 19:52
feedback

3 Answers

up vote 9 down vote accepted

Use awk as follows:

$ echo '*EXTRA File     78223    C:\foo.pdf' | awk '$3 > 1048576 {print $0;}'
$ echo '*EXTRA File     78223    C:\foo.pdf' | awk '$3 > 40000 {print $0;}'
*EXTRA File     78223    C:\foo.pdf
link|improve this answer
Thanks. Not familiar with awk. It looks to be very handy. – mbrownnyc Sep 2 '11 at 20:15
feedback

Also - if you're using a Unix-like userland (like UnxUtils or Cygwin, if you're on Windows), you can use find with the -size parameter to get your file list directly, and then pipe to xargs and do whatever you're trying to do with the selected files.

The general answer to your question (interesting comparisons and other operations) is indeed awk or bash (with bc) or perl - but the specific scenario lends itself to find.

link|improve this answer
Bash can natively perform integer math, check out mywiki.wooledge.org/ArithmeticExpression – astrostl Sep 2 '11 at 20:30
find can also -exec rather than piping to xargs. If xargs-like "all arguments in one command" style is preferred, terminate with + rather than ; Check out mywiki.wooledge.org/… :) – astrostl Sep 2 '11 at 20:32
feedback

In pure Bash:

while read -r _ _ size _; do ((size > 10485760)) && echo "hit"; done < foo.log
link|improve this answer
This can be easily modified to report any field(s) or the entire line if there is a match, and/or custom-define the comparison integer at runtime. If you want that, just LMK. – astrostl Sep 2 '11 at 20:22
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.