Filter .bed file by numbers in final column
Hi,
I would like to filter a .bed file by numbers in the last column:
chr1 0 14400 18
chr1 14400 19000 6
chr1 19000 567400 18
chr1 567400 567800 10
chr1 567800 713200 18
chr1 713200 713800 2
chr1 713800 714600 1
chr1 714600 715400 2
chr1 715400 724000 6
How can I create a new file with lines that only contain 1,2 and 18? like this:
chr1 0 14400 18
chr1 19000 567400 18
chr1 567800 713200 18
chr1 713200 713800 2
chr1 713800 714600 1
chr1 714600 715400 2
Would it involve using the awk command?
Many Thanks
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Rseqc infer_experiment.py: 0 usable reads sampled and unknown data type
written by pubsurfted •
-
Redirect Stdout From twoBitToFa in Bash
written by Laura •
-
Interpreting Bedtools Intersection Between BAM and BED Files
written by Steven Mick •
-
Using multiIntersectBed to filter original bed files
written by williamtmills •
-
How to merge chr+strand+coordinate+score from multiple files?
written by Rae •
-
awk one line command
written by prasoonagar •
-
Modifying NCBI identifiers in BLAST output
written by adityabandla •
-
discordant results between bedTools and awk
written by bioguy24
-
awk select duplicated lines
written by juncheng
-
Count Columns For Each Window
written by roll
I googled and the first hit for "awk filter column by value" was "Using AWK to Filter Rows" : https://www.tim-dennis.com/data/tech/2016/08/09/using-awk-filter-rows.html
Hello kdecoteau!
We believe that this post does not fit the main topic of this site.
Just an awk question, not really bioinformatics.
For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.
If you disagree please tell us why in a reply below, we'll be happy to talk about it.
Cheers!