Timeline for Remove rows from tab delimited files based on a common column with another file
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 5, 2015 at 7:18 | history | edited | cuonglm | CC BY-SA 3.0 |
Posixified
|
| Aug 5, 2014 at 21:05 | comment | added | cmart2112 |
I found if I remove all of the whitespaces with: sed 's/ //g', your solution works perfectly. However, I would like to find a way to perform this without having to remove them as some columns require a space.
|
|
| Aug 5, 2014 at 17:52 | comment | added | cuonglm | Can you give some actual data? | |
| Aug 5, 2014 at 17:44 | comment | added | cmart2112 | @Gnouc: Thanks. I am getting close. But somehow I am getting the entire contents of file2.txt, not just the row that matches in Column_4. GNU Awk 3.1.8 if that helps | |
| Aug 5, 2014 at 17:24 | comment | added | cuonglm | @terdon: Thanks, missing the tab delimiter. Updated my answer. | |
| Aug 5, 2014 at 17:24 | history | edited | cuonglm | CC BY-SA 3.0 |
added 16 characters in body
|
| Aug 5, 2014 at 17:23 | comment | added | terdon♦ |
@cmart2112 yes, it should work. Try adding -F"\t" to make awk read tab separated values. If you have spaces in your fields, that might confuse things.
|
|
| Aug 5, 2014 at 17:21 | comment | added | cmart2112 | Is this expected to function similarly with a file with 30+ columns? I get different results when I change the $4 to $18. | |
| Aug 5, 2014 at 17:12 | history | answered | cuonglm | CC BY-SA 3.0 |