unix - Fastest way to match column from one file to another -


i have 2 files both have on million lines , want print out match first column of file 1 second of file 2.

file_1

snp_a-2131660   1   0.0021 snp_a-1967418   2   0.0005 snp_a-1969580   2   0.0011 snp_a-4263484   1   0.0024 snp_a-1978185   0   0.0014 snp_a-4264431   0   0.0038 snp_a-1980898   2   0.0050 snp_a-1983139   0   0.0011

file_2

"affx-snp_10000979" "rs4147951" "affx-snp_10009702" "rs2022235" "snp_a-2131660" "rs6425720" "affx-snp_10021569" "rs12997193" "affx-snp_10026879" "rs9933410" "affx-snp_10029725" "rs7142489" "affx-snp_10034687" "rs1350088"

matches.txt

"snp_a-2131660" "rs6425720"

right doing, slow. there faster way?

awk '{print $1}' file_1 | while read -r a; grep -h $a file_2; done >> matches.txt

could please try following awk.

awk 'fnr==nr{a[$1]=$0;next} {val=$1;gsub(/\"/,"",val)} (val in a)' file_1 file_2

if want redirect above command's output output file > output.txt(or whatever name output file) @ end of command too.


Comments

Post a Comment

Popular posts from this blog

neo4j - finding mutual friends in a cypher statement starting with three or more persons -

Image
i trying build cypher statement neo4j know 2-n starting nodes name , need find node (if any) can reached of starting nodes. at first tought similar "mutual friend" situation handled (start1)-[*..2]->(main)<-[*..2]-(start2) in case have more 2 starting points around 6 know name. so puzzled how can include third, fourth , on node cypher able find commmon root amongst them. in above example neo4j website need path starting 'dilshad', 'becky' , 'cesar' check if have common friend (anders) excluding 'filipa' , 'emil' not friends of three. so far create statement programmatically looks like match (start1 {name:'person1'}), (start2 {name:'person2'}), (start3 {name: 'person3'}), (main) (start1)-[*..2]->(main) , (start2)-[*..2]->(main) , (start3)-[*..2]->(main) return distinct main but wondering if there more elegant / efficient way in cypher possibly use list of names parameter ...
Read more

php - How to remove letter in front of the word laravel -

Image
based on picture above result of var_dump() , dd() of same variable ,when var_dump() , apostrophe (') symbol in black diamond of question mark , when dd() same variable , apostrophe can seen letter 'b' appear in front of words what want can me result : loreal's sdn bhd and @ same time want remove special character ( excluding these 4 symbols (-) ,(_) ,('),(,) ) simply escape special character resolve issue. mysqli_real_escape_string resolve issue. $name = mysqli_real_escape_string($request()->user); or use addslashes function() $name = addslashes($request()->user);
Read more

linux - Why does bash short curcuit fail in crontab? -

if in terminal do [ $(/usr/bin/date +"%y%m%d") -le 20171209 ] && echo aaa >> /tmp/a it works. if in crontab -e * * * * * echo aaa >> /tmp/a then works. if in crontab -e * * * * * [ $(/usr/bin/date +"%y%m%d") -le 20171209 ] && echo aaa >> /tmp/a then nothing happens. looking @ /var/log/cron see sep 12 08:36:01 enote crond[8809]: (root) cmd ([ $(/usr/bin/date +") question can explain issue is? percent sign has special meaning in crontab, must escaped \% man 5 crontab /percent percent-signs (%) in command, unless escaped backslash (\), changed newline characters, , data after first % sent command standard input.
Read more