Extraction of every n-th and m-th columns

Hi. Everyone!

I have a dataset similar to below. It has multiple samples, and each sample has multiple values.

ID    Sample1                     Sample2                    Sample3
xx    val1 val2 va3 val4 val5     val1 val2 va3 val4 val5    val1 val2 va3 val4 val5

How can I extract multiple columns from each sample (i.e. val2 and val4 from each sample) assuming all the data are tab delimited?

Thank you!

bash command

• 1,443 views • link

updated 8.8 years ago by Alex Reynolds

• written 8.8 years ago by mbk0asis

1 answer

$ awk -v M=1234 -v N=4567 -v FS="\t" -v OFS="\t" '{ print $M, $N; }' in.txt > out.txt

Replace M and N with your column indices of interest.

You could also use cut -fM,N in.txt > out.txt, so long as M < N. Using awk gets around quirks in cut.

• 0 views • link

written 8.8 years ago by Alex Reynolds

More posts like this

how extract information from the output text file?
written 2.8 years ago by sata72 •

I have several output files and want extract some information from them. ``` sample1.out sample2.out sample3.out .. .. ``` These information are there in each …
change format of table in R. bring the row to coulmn
written 3.3 years ago by sata72 •

I have a 22 sample, with another column information about each sample, i want to change the samples to another format as below in output …
Error in reading tab delimited file
written 4.8 years ago by arshad1292 •

I have two files 1) leafdata file with readcount values 2) metadata file with sample information... both are in tab delimited format. They look like …
Creating Count Matrix
written 7.5 years ago by lamia_203

I have to create a count table with: Gene ID Sample1 Sample2 Sample3 ENSG... 297 0 0 So far I have files with their individual …
Merging data coloum wise in R
written 8.6 years ago by David_emir

Hello All, I am using R to merge two different CSV file into one new file. both of them has got gene name (1st column) …
Creation of Transcript expression file
written 8.9 years ago by mail2steff

Dear team I am analysing AS events in Arabidopsis thaliana using SUPPA. I predicted AS_events using generateEvents option. For calculating PSI (next step), it requires …
How to read multiple samples with DESeq2?
written 9.3 years ago by mirzaei86.vahid •

Hello I have a count file which has multiple columns, (one column for one sample). As I found, In DESeq2 we should insert count files …
replace value of each rows with value of column?
written 10.6 years ago by star

<pre> I have a table like as below. I like to replace each sample value base on comparing with third first columns and code each …
replace value of each rows with value of column?
written 10.7 years ago by star

<pre> I have a table like as below. I like to replace each sample value base on comparing with third first columns and code each …
One sample pooled in a whole lane vs multiple sample in each lane
written 10.8 years ago by bob •

Dear All, I have paired-end RNA-seq data sequenced using HiSeq 4000. One sample (sample#1) out of 8 samples is pooled in a whole lane and …