Differences between revisions 1 and 2
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
Describe JoinFiles here. |
##acl MoinPagesEditorGroup:read,write,delete,revert All:read |
Line 17: | Line 18: |
the input files need to be sorted based on the comparison key Using awk in a shell script {{{ File1 = chr locations File2 = GFF file awk ' NR==FNR{ a[NR]=$0 next } { for(i=1;i<NR;i++) if (a[i] > $4 && a[i] < $5) print $2,$3, "falls between", $4 "and", $5 "at location", a[i] } ' File1 File2 > Outfile_Chr1 & }}} |
Join two files on a common field and re-arrange the output:
$ cat a.txt cust1, ac1, 100 cust2, ac2, 200 $ cat b.txt 100000, cust1, 100 2000000, cust2, 200 $ join -a 1 -a 2 -1 3 -2 3 -t"," -o 1.1 1.2 1.3 2.1 a.txt b.txt cust1, ac1, 100,100000 cust2, ac2, 200,2000000
the input files need to be sorted based on the comparison key
Using awk in a shell script
File1 = chr locations File2 = GFF file awk ' NR==FNR{ a[NR]=$0 next } { for(i=1;i<NR;i++) if (a[i] > $4 && a[i] < $5) print $2,$3, "falls between", $4 "and", $5 "at location", a[i] } ' File1 File2 > Outfile_Chr1 &