UNIX for Dummies Questions & Answers

Hi,

I have two text files (1.txt and 2.txt).

2.txt contains two columns which are extracted from 1.txt using a simple if(condition) print.

I want to:
- count how many times the values contained in 2.txt appear in 1.txt
-if they appear just one time, I have to delete the entire row in 1.txt where they are AND I have also to replace the value of the second column of 2.txt with the value of the first column of 2.txt in third file 3.txt


I get lost with arrays I guess.
I tried with

Code:

NR==FNR {to[$2]++;next}
END{ for(var in to) print var, "appear", to[var]," times"} file 2 file1

but the output is not what I want.


Thanks,
Pintug

Show the input you have and the output you want.

For example I have 1.txt

2.txt is
I should obtain a 1.txt modified , i.e. the row " 2 3 " does not appear because "3" appears just one time in 1.txt

I will then have to replace "3" with "2" all along a third file 3.txt . I can handle this with just one specific string, but here I have to use arrays to run it automatically..


Hope it's clearer now

Do you mean all values in 2.txt or only values in column 2 in 2.txt should not appear only once in 1.txt ?

try:

Code:

awk 'NR==FNR {a[$2]++; next} a[$2]!=1' 2.txt 1.txt

@rdrtx1 got exactly what I had to do!! Thank you so much!!!