Timeline for awk: find common data between two files
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 5, 2018 at 12:50 | answer | added | steeldriver | timeline score: 2 | |
| Nov 5, 2018 at 7:57 | comment | added | Mandeep Singh | awk 'BEGIN{FS=OFS="|"}NR==FNR{a[$0];next}{for(i in a)if(index(i,$2)==1) print i,$1}' file1 file2... Tried this so far.. not able to get the desired output.. | |
| Nov 5, 2018 at 7:56 | comment | added | Mandeep Singh | Sort order is not important until data is as expected.. All keys of File2 are in File1.. File2 is sub set of File1.. File2 have lesser lines from File1.. | |
| Nov 5, 2018 at 7:52 | comment | added | nohillside | What have you tried so far? Is sort order important or can this be changed during the process? Are all keys of File 1 in File 2 (and vice versa), or does one of the files have less lines than the other? | |
| Nov 5, 2018 at 7:19 | history | edited | Romeo Ninov | CC BY-SA 4.0 | code reformat |
| Nov 5, 2018 at 6:56 | history | asked | Mandeep Singh | CC BY-SA 4.0 |