Shell Programming and Scripting

hmmm. I don't quite follow how you get from one to the other given 2 files....
Is there a common field between the 2 files?
Please explain verbally - never mind the script....

there are 2 files, both have the value 4300 followed by some codes.
Now we get a request to update the codes.

So the 1st file is the original file which has the value 4300 followed by some codes. The 2nd file also has the value 4300 followed by some more codes which are to be appended.

so when i append the files, i am not able to remove the duplocates after the value 4300 so the result is coming as:-
4300 233445569

Suppose 4300 is a key against which we need to update the values........

please define 'append the field'.
Are concatenating 2 fields in some manner (if so how) and then want to remove sequential digits/letters of the same value?
This is still too vague of a requirement. Please take one record from both files (say 4300) and show how you're 'appending' and how you're 'removing duplicates'.

for gnu awk, try:

Code:

awk '
   NR == FNR { a[$1]=$2 ; b[$1]=$0 ; next}
   {b[$1]= $1 " " $2 a[$1]}
   END {
      for (i in b) {
         fc=b[i]; sub(" .*", "", fc);
         bts=b[i]; sub(".* ", "", bts);
         for (n=1; n<=length(bts); n++) ba[substr(bts,n,1)]=substr(bts,n,1);
         ic=asort(ba,ab) ; bts="";
         for (j=1; j<=ic; j++) {bts=bts ab[j]; delete ba[ab[j]]; delete ab[j]; }
         print fc, bts;
      }
   }
' File1 File2 | sort