Shell Programming and Scripting

Code:

awk 'NR == FNR { 
  x[$1,$3]
  y[FNR] = $2 
  next 
}
!(($1,$3) in x) { 
  if (y[FNR]) {
    $2 = y[FNR]
  }
  print
}' FS="~" OFS="~" file2 file1

Thanks awk master radoulov,
It's works, can you explain me how this exacly works, i want to understant

Best Regards
PP

Thank you but I'm not awk master at all,
visit comp.lang.awk and comp.unix.shell to see the real masters

Sure, line by line.

Code:

NR == FNR

While reading the first file - NR is the total number of input records seen so far, FNR - the input record number in the current input file, so the statement above is true only while we read the first file.

Code:

x[$1,$3]

Store $1 and $3 as indexes in the array x.
Populate the array y: the indexes are FNR,
the elements $2.

Code:

next

Skip the record(s) processed by these actions for the next statement(s)/action(s) (the code that follows will process
only the records that follow (the second file).

Code:

!(($1,$3) in x)

Now reading the second file. For the recors whose $1 and $3 are not in array x (in the first file) if the value of y[FNR]
(FNR now is the second file's record number) is not null, assign that value to $2.

Code:

print

Print those records.

Code:

FS="~" OFS="~" file2 file1

I don't think this need explanation.

HTH

Thanks for detail explanation ? I have some problem if file2 is empty ? is there a posibility to handle that problem ?

Yes,
NR == FNR will be true for the second file (file1 in this case),
so you could use something like this:

Code:

awk '!f { 
  x[$1,$3]
  y[FNR] = $2 
  next 
}
!(($1,$3) in x) { 
  if (y[FNR]) {
    $2 = y[FNR]
  }
  print
}' FS="~" OFS="~" file2 f=1 file1

I have some problem with replacing $2 from 2nd file; i think it is not cleaning if recor not found in file 2
all my deatils:
AWK FILE : match_files2_o.awk

BEGIN { printf "%-5s|%-10s|%-9s|%-9s|%-9s|%-70s|%-9s|%-s\n","Count", "VT", "Date", "Time","From","Alert Message","Instance",""}
NR == FNR {
x[$1,$7]
y[FNR] = $2
next
}
!(($1,$7) in x) {
if (y[FNR]) {
$2 = y[FNR]
}
{ printf "%-5s|%-10s|%-9s|%-9s|%-9s|%-70s|%-9s|%-s\n", $1, $2, $3, $4, $6, $7, $8, ""}
}

FILE 2: managed_event_log.170108
~~~~~~~~~
12~VT0000001~ 17-01-08~10:02:32~2~KAZUAT1~kaz/switch/bin/ifstart for KAZUAT1 TOO MANY PROCESSES 001459~emeflxci~FLEX_daemons~SWITCH:KAZ:T01~CRITICAL~~100
12~VT0000001~ 17-01-08~10:02:32~1~KAZUAT1~ifpoll_KZ for KAZUAT1 NOT EXIST 001459~emeflxci~FLEX_daemons~SWITCH:KAZ:T01~CRITICAL~~100

FILE 1: managed_event_log.170108

12~~ 17-01-08~10:02:32~1~KAZUAT1~ifpoll_KZ for KAZUAT1 NOT EXIST 001459~emeflxci~FLEX_daemons~SWITCH:KAZ:T01~CRITICAL~~100
12~~ 17-01-08~10:02:32~1~KAZUAT1~ifreader_KZ for KAZUAT1 NOT EXIST 001459~emeflxci~FLEX_daemons~SWITCH:KAZ:T01~CRITICAL~~100
12~~ 17-01-08~10:02:32~2~ISRUAT3~isr/switch/bin/ifstart for ISRUAT3 TOO MANY PROCESSES 102802~emeflxci~FLEX_daemons~SWITCH:ISR:T01~CRITICAL~~100
12~~ 17-01-08~10:02:32~2~KAZUAT1~kaz/switch/bin/ifstart for KAZUAT1 TOO MANY PROCESSES 001459~emeflxci~FLEX_daemons~SWITCH:KAZ:T01~CRITICAL~~100
1~~ 17-01-08~00:03:52~1~AUTOSYS~T01_ADM_155700_YYYYMMDD_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:03:10~1~AUTOSYS~T01_ADM_BO_yy-mm-dd_today_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:02:46~1~AUTOSYS~T01_ADM_BO_yy_mm_dd_today_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:03:11~1~AUTOSYS~T01_ADM_BO_yymmdd_today_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:03:08~1~AUTOSYS~T01_ADM_BO_yyyy-mm-dd_today_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:03:05~1~AUTOSYS~T01_ADM_BO_yyyy_mm_dd_today_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:03:04~1~AUTOSYS~T01_ADM_BO_yyyymmdd_today_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:05:39~1~AUTOSYS~T01_ADM_DateGvars_B~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:02:43~1~AUTOSYS~T01_ADM_GVAR_10235_DDMMYY_TODAY_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:04:17~1~AUTOSYS~T01_ADM_GVAR_149388_DATEDDMMMYYYY_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:04:23~1~AUTOSYS~T01_ADM_GVAR_149388_DATEMMMDD_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:03:11~1~AUTOSYS~T01_ADM_GVAR_35612_DATEyyyymmdd_LASTBUSDAY_C~T01~autosys~~JOBFAILURE~~
1~~ 17-01-08~00:04:57~1~AUTOSYS~T01_ADM_make_priv_C~T01~autosys~~JOBFAILURE~~

I execute it like this:
/usr/xpg4/bin/awk -f match_files2_o.awk FS="~" OFS="~" managed_event_log.output.170108 all_event_log.170108

AND HAVE SUCH OUTPUT WHICH IS WORNG:
Count|VT |Date |Time |From |Alert Message |Instance |
12 |VT0000001 | 17-01-08|10:02:32 |KAZUAT1 |ifreader_KZ for KAZUAT1 NOT EXIST 001459 |emeflxci |
12 |VT0000001 | 17-01-08|10:02:32 |ISRUAT3 |isr/switch/bin/ifstart for ISRUAT3 TOO MANY PROCESSES 102802 |emeflxci |
1 | | 17-01-08|00:03:52 |AUTOSYS |T01_ADM_155700_YYYYMMDD_C |T01 |
1 | | 17-01-08|00:03:10 |AUTOSYS |T01_ADM_BO_yy-mm-dd_today_C |T01 |
1 | | 17-01-08|00:02:46 |AUTOSYS |T01_ADM_BO_yy_mm_dd_today_C |T01 |
1 | | 17-01-08|00:03:11 |AUTOSYS |T01_ADM_BO_yymmdd_today_C |T01 |
1 | | 17-01-08|00:03:08 |AUTOSYS |T01_ADM_BO_yyyy-mm-dd_today_C |T01 |
1 | | 17-01-08|00:03:05 |AUTOSYS |T01_ADM_BO_yyyy_mm_dd_today_C |T01 |
1 | | 17-01-08|00:03:04 |AUTOSYS |T01_ADM_BO_yyyymmdd_today_C |T01 |
1 | | 17-01-08|00:05:39 |AUTOSYS |T01_ADM_DateGvars_B |T01 |
1 | | 17-01-08|00:02:43 |AUTOSYS |T01_ADM_GVAR_10235_DDMMYY_TODAY_C |T01 |
1 | | 17-01-08|00:04:17 |AUTOSYS |T01_ADM_GVAR_149388_DATEDDMMMYYYY_C |T01 |
1 | | 17-01-08|00:04:23 |AUTOSYS |T01_ADM_GVAR_149388_DATEMMMDD_C |T01 |
1 | | 17-01-08|00:03:11 |AUTOSYS |T01_ADM_GVAR_35612_DATEyyyymmdd_LASTBUSDAY_C |T01 |
1 | | 17-01-08|00:04:57 |AUTOSYS |T01_ADM_make_priv_C |T01 |

Please help i hope one more time

Could you post the desired output (the correct one)?