awk capability cut capability

Question

I am using the following ssh command to get a list of ids. Now I want to

get only ids greater than a given number in the list of ids; let's say "231219" in this case. How can I incorporate that?
I have a local file "ids_ignore.txt"; anyid we put in this list should be ignored by the command..

Can awk or cut do the above?

ssh -p 29418 company.com gerrit query --commit-message --files --current-patch-set \
    status:open project:platform/code branch:master |
grep refs | cut -f4 -d'/'

OUTPUT:-

You question isn't clear, add the output from the `ssh` command. — Chris Seymour, Jan 25 '13 at 23:58
If that is the output from the ssh command then why are you grepping for `refs` and cutting as it's a list of digits? I believe what you have posted is your expected output. — Chris Seymour, Jan 26 '13 at 00:23

score 1 · Answer 1 · answered Jan 25 '13 at 23:58

1

... | awk '$1 > max' max=8888 | grep -v -F -f ids_ignore.txt

Or, if you want to do it all with awk:

 ... | awk 'NR==FNR{ no[$1]++ } 
        NR!=FNR && $1 > max && ! no[$1]' max=NNN ids_ignore.txt -

answered Jan 25 '13 at 23:58

William Pursell

204,365
48
270
300

I still see the ids being printed by the ssh command even for the ones in ids_ignore.txt – user1934146 Jan 26 '13 at 00:22
I treid both the above ways..still I see the numbers presen in ids_ignore.txt is beign printed – user1934146 Jan 26 '13 at 00:43

score 0 · Answer 2 · answered Jan 26 '13 at 00:56

cut cannot do numeric comparison on the input fields, it's just a simple field extraction tool. awk can do the work of grep and cut:

ssh -p 29418 company.com gerrit ... |
awk -F/ -v min=231219 '
    NR == FNR {ignore[$1]; next} 
    /refs/ && $4>min && !($4 in ignore) {print $4}
' ids_ignore.txt -

The trailing - is important at the end of the awk command: it tells awk to read from stdin after it reads the ids_ignore file.

awk capability cut capability

2 Answers2