Timeline for How do I print all records in file 1 but note the records that do not match file2?
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 22, 2018 at 13:51 | history | made wiki | Post Made Community Wiki by don_crissti | ||
| Dec 4, 2015 at 13:46 | history | edited | don_crissti | CC BY-SA 3.0 | deleted 12 characters in body |
| Dec 4, 2015 at 5:46 | comment | added | jamespower | I see what my issue is... I can get what I need from your awk command using paste with my file2... unix.stackexchange.com/questions/247223/… | |
| Dec 4, 2015 at 5:08 | vote | accept | jamespower | ||
| Dec 4, 2015 at 5:03 | vote | accept | jamespower | ||
| Dec 4, 2015 at 5:05 | |||||
| Dec 4, 2015 at 5:03 | comment | added | jamespower | then it prints the whole line as "NoMatch" if it doesn't find it... there is no hope I will understand why tonight I guess, I will use the awk though at this point, thanks so much for all your help! | |
| Dec 4, 2015 at 4:57 | history | edited | don_crissti | CC BY-SA 3.0 | added 167 characters in body |
| Dec 4, 2015 at 4:50 | comment | added | jamespower | I think I am using the brackets incorrectly, I get a syntax error... sorry I am a beginner... if I try this one step at a time and get the sortedFile1 without header and sortedFile2 without header in tab delimited format and then try this: { join -t $'\t' -a1 -e "NoMatch" -1 1 -2 1 -o 1.2,2.1 sortedFile2; } sortedFile1 ) | |
| Dec 4, 2015 at 4:39 | comment | added | jamespower | Thank you... I still can't get it to print my second value for the output, it prints "NoMatch" for the whole row...I don't understand why... | |
| Dec 4, 2015 at 4:21 | comment | added | jamespower | Thanks so much don_crissti! Can I ask why I can't just ignore the header since it won't match to the other file anyway? I think I have been doing this wrong all along :/ | |
| Dec 4, 2015 at 4:09 | history | answered | don_crissti | CC BY-SA 3.0 |