UNIX for Dummies Questions & Answers

Hi All,

I have a requirement, I had a parent directory Land under that we have sub directories
Yesterday,
Today and
Tommorrow

And we have a file test.txt under the above directories Yesterday, Today and Tommorrow

The data in the file test.txt under Yesterday folder is
Header|2011-12-01
DATA|TOTAL1
DATA|TOTAL2
EOF

The data in the file test.txt under Today folder is
Header|2011-13-01
DATA|TOTAL3
DATA|TOTAL4
EOF

The data in the file test.txt under Tommorrow folder is
Header|2011-14-01
DATA|TOTAL5
DATA|TOTAL6
EOF

I want to get only the 1st records after removing header records from the files like below

DATA|TOTAL1
DATA|TOTAL3
DATA|TOTAL5

I used below command

I used below command awk -F"|" 'BEGIN{IGNORECASE=1;} $1~/DATA/' Land/*/test.txt
I'm getting all the records and the data is as shown below

DATA|TOTAL1
DATA|TOTAL2
DATA|TOTAL3
DATA|TOTAL4
DATA|TOTAL5
DATA|TOTAL6


Thanks,
Raju

One way.

Code:

head -2 /Land/Yesterday/test.txt | tail -1
head -2 /Land/Today/test.txt | tail -1
head -2 /Land/Tommorrow/test.txt | tail -1

Btw. It's spelt "tomorrow" !

Hi Methyl,



Thanks for the reply, I don't know how many subfolders I will have under Land directory. I gave only 3 subfolders as an example. That is whay I mentioned '*' in my command to get all the Subfolders under Land

awk -F"|" 'BEGIN{IGNORECASE=1;} $1~/DATA/' Land/*/test.txt




Thanks,
Raju

Try...

Code:

awk 'BEGIN{IGNORECASE=1;} $1~/DATA/&&!a[FILENAME]++' Land/*/text.txt

Code:

find . -type f -exec awk 'NR==2' {} \;

More than one way to do this. Another way in addtion to using find command:

Code:

 
ls /Land/*/test.txt | xargs -I{} awk 'NR==2' {}