Shell Programming and Scripting

my files are as follows

Code:

fileA sepearated by tab /t
00 lieferungen 
00 attractiop
01 done
02 forness
03 rasp
04 alwaysisng
04 funny
05 done1

fileB

Code:

funnymou120112
funnymou234470
mou3raspnhdhv
rddfgmoudone1438748

so all those record which are greater than 3 and which are not present in fileB are to be redirected to third file.
eg : as in above file four records
03 rasp
04 alwaysisng
04 funny
05 done1
are greter than 3 . so rasp is compared to in each line of fileB . as rasp is present in any line of fileB .it is not redirrected in output file .. if rasp is not present in any line of fileB then it is redirected to output file . so output file for above will look like

o/p

Code:

04 alwaysisng

plz help. records more than 80000.

not in pure awk. but it should work.

Code:

 
$ nawk '$1>3{print $2}' file1.txt | while read a; do grep "$a" file2.txt > /dev/null || grep $a file1.txt; done
04 alwaysisng

Code:

 awk 'NR==FNR{a[$0];next}$1>3{for (k in a){if (k ~ $2)next}print}'  fileB fileA

Guru.

thanks guruprasadpr ,

it is working.

@itkamaraj : for nawk . it is saying . cannot find commad nawk..

On some systems, plain awk is nawk anyway. so just try that.

On other systems, you must use nawk to get anything remotely modern...

try this

Code:

# awk 'NR==FNR{sub(/./,"",$1);if($1>2&&$1~/^[0-9]/)a[$0]=$1;next}{b[$0]++}
END{c=0;for(i in a){for(j in b){if(j~a[i])c++};;if(c==0){print i}c=0}
}' file1 file2
4 alwaysisng

regards
ygemici

hi guruprasadpr,
i used this

Code:

awk 'NR==FNR{a[$0];next}$1>3{for (k in a){if (k ~ $2)next}print}'  fileB fileA

i have one more requirement as for records of fileA as .. after all this execution if the column 1 of fileA is greater than 25 , then that record must be deleted from fileA and saved again in fileA

so if record in fileA is

26 alwaysisng

so as it is greater than 25 it should then be removed from fileA.
so fileA aftert execution should not contain records greater than 25.

many thanks in advance.

---------- Post updated 02-21-12 at 03:15 AM ---------- Previous update was 02-20-12 at 08:57 AM ----------


hi guruprasadpr,
i used this

Code:

awk 'NR==FNR{a[$0];next}$1>3{for (k in a){if (k ~ $2)next}print}'  fileB fileA

i have one more requirement as for records of fileA as .. after all this execution if the column 1 of fileA is greater than 25 , then that record must be deleted from fileA and saved again in fileA

so if record in fileA is

26 alwaysisng

so as it is greater than 25 it should then be removed from fileA.
so fileA aftert execution should not contain records greater than 25.

many thanks in advance.