Looking for some help, I have two files, one is a large list of various names the other is coordinates. both files start each line with an 8 digit code. I want to lookup 8 digit line code from File1 and copy the line contents to all matching line codes in File2.
(File1) Only one occurence of hash / name.
136667ED ap1_01_a_ap1_01_rails_07 035B337C ap1_01_a_arrows_005 79546F82 ap1_01_a_centreline_010 0E1D31E7 prop_bush_med_02
(File2) Some have multiple hash copies like 0E1D31E7, with different coordinates.
136667ED -1294.6945,-2376.0317,21.8279 035B337C -1314.6719,-2721.7378,12.9467 79546F82 -1283.1066,-2529.9771,12.9635 0E1D31E7 1919.4160,-1814.3889,160.5210 0E1D31E7 1919.9885,-2628.2529,0.7537 0E1D31E7 192.0235,-2603.1790,4.9978 0E1D31E7 192.1050,4950.3540,389.4736
Below is how I would like them, The 8 Digit code / name, copied into any code line match in file 2.
136667ED -1294.6945,-2376.0317,21.8279 136667ED ap1_01_a_ap1_01_rails_07 035B337C -1314.6719,-2721.7378,12.9467 035B337C ap1_01_a_arrows_005 79546F82 -1283.1066,-2529.9771,12.9635 79546F82 ap1_01_a_centreline_010 0E1D31E7 1919.4160,-1814.3889,160.5210 0E1D31E7 prop_bush_med_02 0E1D31E7 1919.9885,-2628.2529,0.7537 0E1D31E7 prop_bush_med_02 0E1D31E7 192.0235,-2603.1790,4.9978 0E1D31E7 prop_bush_med_02 0E1D31E7 192.1050,4950.3540,389.4736 0E1D31E7 prop_bush_med_02
This may work, I dont know how to run any of these commands. I'm using windows.