File1



9000|9000|WW|1|1|SL|472|472|LC|2272|1072|MTY

9000|9000|WW|1|1|SL|470|470|MC|1270|1172|MPVT

9000|9000|WW|1|1|SL|472|472|LC|1072|1672|MBD

9000|9000|WW|1|1|SL|473|473|LF|1173|1173|MTY





File2

DPT.1072 CP~ Apr 1514283.914

DPT.1172 CP~ Apr 967882.506

DPT.1672 CP~ Apr 545199.000

DPT.1772 CP~ Apr 912656.817







Compare the column 11 of file 1 with the 1st column of file2. The 1st column of file2 contains a prefix dpt. also. We need to compare file2 with file1 and in the output we should get all the values from file2 that are present in file1. We should not remove dpt. from the output. It will always be 8 characters in 1st column of file2 (e.g DPT.1072).



The output should be:



DPT.1072 CP~ Apr 1514283.914

DPT.1172 CP~ Apr 967882.506

DPT.1672 CP~ Apr 545199.000



I am thankful for your help.

perhaps like this:

awk -F "|" '{print $11}' testing|xargs -i grep {} testing1|awk '{print$1}' testing1

testing is inputfile1 testing1 is comparation file

thanks

if you want all the output from file2
awk -F "|" '{print $11}' testing|xargs -i grep {} testing1|awk '{print$0}' testing1

Thanks for your reply. I will try this. Only thing I am not sure is the prefix DPT. in file2. We want to compare two files after removing prefix DPT. but we do NOT want to remove DPT. from the output. Means in the comparsion command only we need to compare without DPT.---------May be at the time of comparsion something like substr(col1 of file2, 4,8)...........

Thanks Much.

awk -F"|" field separator

FNR==NR {a[$11]++; next} buid an array with 11th field of file1 and give value 1 (default value 0+1) to it.

a[substr($0, 5, 4)] {print} if a[nnnn] is TRUE (1)---> print line from file2

Thank-You. It worked fine.

hi can you say me what xargs is all about...


thanks
krips.