Shell Programming and Scripting

I need to your help. I want write a script search for rows in file1 if exist in file2 it will print rows from file2 else it will print rows from file1 with out any duplicate


Example:
file1

4599207
47182983
46900870
21015724
63358010
222222
33333


file2

4599207 ,20070914 ,abc
47182983,20080513 ,abc
46900870,20080513 ,abc
21015724,20080617 ,abc
63358010,20080520 ,abc
25985516,20080624 ,abc
92829623,20080712 ,abc
58015436,20080629 ,abc
53139549,20080629 ,abc
21644907,20080617 ,abc
82325402,20080707 ,abc
82325406,20080707 ,abc
82325404,20080707 ,abc
82325405,20080707 ,abc





Output

4599207 ,20070914 ,abc
47182983,20080513 ,abc
46900870,20080513 ,abc
21015724 20080617 ,abc
63358010,20080520 ,abc
222222
33333

Code:

while read rec
do
grep -f "$rec" file1
if [[ $? -ne 0 ]] ; then
  echo "$rec"
fi
done < file2

Try (and adapt) the following script (assumes that records in file are fixed length) :

Code:

awk '
BEGIN {
   FS = OFS = ",";
}
NR==FNR {
   datas[$1] = $0;
   next;
}
{
   if ($1 in datas)
      print datas[$1]
   else
      print $0;
}
' file2 file1

If records in file1 aren't fixed length :

Code:

awk '
BEGIN {
   FS = OFS = ",";
}
NR==FNR {
   sub(/[[:space:]]*/, "", $1)
   datas[$1] = $0;
   next;
}
{
   sub(/[[:space:]]*/, "", $1)
   if ($1 in datas)
      print datas[$1]
   else
      print $0;
}

' kmu2.dat kmu1.dat

Jean-Pierre.

Or:

Code:

awk -F, 'NR==FNR{a[$1]=$0;next}$0 in a{print a[$0];next}1' file2 file1

Regards

Thanks