Hi All,
I have two files
File1
frame,007C1 server1_Parent
frame,007C3 server2_Silver
frame,007EE server3_Bronze
frame,00855 server4_Parent
frame,00856 server4_Parent
frame,00858 server5_Parent
frame,008FA server6_Silver
frame,008FB server6_Silver
frame,008FC server6_Silver
frame,008FD server6_Silver
frame,008FE server6_Silver
frame,008FF server6_Silver
frame,00900 server6_Silver
frame,00901 server6_Silver
frame,00902 server6_Silver
frame,00903 server6_Silver
frame,00904 server6_Silver
frame,00905 server6_Silver
frame,00955 server7_Silver
frame,00956 server7_Silver
frame,00957 server7_Silver
File2
00856 00E5C R1:3 RW RW RW A..1. 0 0 RW WD Consistent
00858 000E2 R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
008FA 00AE8 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
008FE 00AEC R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
008FF 00AED R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
00905 00AF3 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
00955 00BE1 R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
00956 00BE2 R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
00957 00BE3 R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
00900 00AEE R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
00901 00AEF R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
00902 00AF0 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
00903 00AF1 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
00904 00AF2 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
007C1 005CD R1:1 ?? RW RW S..1. 0 0 RW WD Synchronized
007C3 005CE R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
007EE 000EE R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
00855 00E5B R1:3 RW RW RW A..1. 0 0 RW WD Consistent
008FB 00AE9 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
008FC 00AEA R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
008FD 00AEB R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
I need output
frame,007C1 server1_Parent 007C1 005CD R1:1 ?? RW RW S..1. 0 0 RW WD Synchronized
frame,007C3 server2_Silver 007C3 005CE R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,007EE server3_Bronze 007EE 000EE R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
frame,00855 server4_Parent 00855 00E5B R1:3 RW RW RW A..1. 0 0 RW WD Consistent
frame,00856 server4_Parent 00856 00E5C R1:3 RW RW RW A..1. 0 0 RW WD Consistent
frame,00858 server5_Parent 00858 000E2 R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
frame,008FA server6_Silver 008FA 00AE8 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,008FB server6_Silver 008FB 00AE9 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,008FC server6_Silver 008FC 00AEA R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,008FD server6_Silver 008FD 00AEB R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,008FE server6_Silver 008FE 00AEC R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,008FF server6_Silver 008FF 00AED R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,00900 server6_Silver 00900 00AEE R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,00901 server6_Silver 00901 00AEF R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,00902 server6_Silver 00902 00AF0 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,00903 server6_Silver 00903 00AF1 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,00904 server6_Silver 00904 00AF2 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,00905 server6_Silver 00905 00AF3 R1:1 ?? RW RW C.D1. 0 0 RW WD Synchronized
frame,00955 server7_Silver 00955 00BE1 R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
frame,00956 server7_Silver 00956 00BE2 R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
frame,00957 server7_Silver 00957 00BE3 R1:1 RW RW RW S..1. 0 0 RW WD Synchronized
Need the check the device from colume2 of file1 and check if the device was there in file-two from colume1 and i need to append both line to one line. I dont want for loop to each device since it was taking time any other solution.