How to skip a record with awk

Question

I have a large number of files in a log-directory, whose names were time-stamped (in this case with date +%b[...]).

I want to write a POSIX compliant one-liner that will:

either

• skip lines output from ls -ltc that have 2 fields or less (as seen by awk) and do not contain the regexp constant /Jul/

or

• skip the first line output by ls -ltc and any line not matching /Jul/.

The result is the same for my purpose as only the first line consists of two fields (as seen by awk).

I tried:

> ll -tc | rm $(awk --posix 'NF > 2 && !/Jul/ {print $NF;}')
> ll -tc | rm $(awk --posix 'NF > 2 !/Jul/ {print $NF;}')

Both have bad syntax because a condition on NF apparently does not coexist nicely with a regexp matching condition the way ls | awk '/foo/ && /bar/'would for instance.

Can sb give me pointers on how to either skip any arbitrary record and/or apply the arithmetic condition on NF and the regexp pattern matching at the same time ? I did look around but could not find the documented syntax I am looking for...

Answer 1

Either

awk 'NF<=2 || /Jul/ {next} {print}'

or

awk 'NR==1 || /Jul/ {next} {print}'

or, inverting the logic to shorten the commands, either

awk 'NF>2 && !/Jul/ {print}'

or

awk 'NR!=1 && !/Jul/ {print}'

~$ cat input
first line
Gen second third
Feb second third
Mar second third
Apr second third
May second third
Jun second third
Jul second third
Aug second third
Sep second third
Oct second third
Nov second third
Dec second third
~$ awk 'NF<=2 || /Jul/ {next} {print}' input
Gen second third
Feb second third
Mar second third
Apr second third
May second third
Jun second third
Aug second third
Sep second third
Oct second third
Nov second third
Dec second third
~$ awk 'NR==1 || /Jul/ {next} {print}' input
Gen second third
Feb second third
Mar second third
Apr second third
May second third
Jun second third
Aug second third
Sep second third
Oct second third
Nov second third
Dec second third

Answer 2

@Kos has given an absolutely correct answer to your question.

But I think that you're trying to solve a problem that is not a problem. To delete files that match a certain criteria, you should use find with the parameter -delete.

eg:

find . -type f -newermt 2015-07-07  ! -newermt 2015-07-08 -delete
find . -type f -newerat 2015-07-07  ! -newerat 2015-07-08 -delete