Search Results

This one is working dont know how it compare the file. I tried to put | between append not able to do. How i can add that

---------- Post updated at 01:07 PM ---------- Previous update was at...

I need to check the column 3 from file1 and compare it with Colume1 of file 1 and append and update the record if not found. But dont know how to update this if the file was not having any comma

...

sorry to bump any help on this

I used same code but it was not comparing


awk 'FNR == NR {T[$2] = $0; next} $0 = $0 "|" (T[$NF]?T[$NF]:"Notfound")' FS="," file1 file2

533,000A3 Server1_Parent 000A3 00666 ...

thanks it resolved now.

I ran the script by removing FS=" " same output for all record it was updating not found.

THis is original input file i need check the WWN from file1 and append the line if the WWn found. If not mark has notfound


Switch1, 381 12 45 F-Port 50:00:09:75:50:0d:bd:da
switch2, 8 8 3c0800...

Is there any number i need to change NR {T[$2]


awk 'FNR == NR {T[$2] = $0; next} $0 = $0 "|" (T[$NF]?T[$NF]:"Notfound")' FS="," file1 FS=" " file2

Now i have input like this. For all record...

Hi RudiC,

This code is working but i have some other issue in input file. So i am getting for lot of wwn not found.

There is some issue in filter in file1. I am checking on that but your code...

Hi RudiC,

I dont have much info awk 'FNR == NR Dont know how to Vlookup

take the third ROW from File1
And check with ROW fifth or sixth from File2

File1


alias:server1_00,20:f1:0a:25:b5:03:02:90
alias:server2_00,20:f1:0a:25:b5:03:02:91
alias:server3_00,50:00:09:75:50:0d:bd:da
alias:server4_00,20:f1:0a:25:b5:03:02:93...