unix - How to move all strings in one file that match the lines of another to columns in an output file? -


i have 2 files, each 1 column this:

file 1

chr1 106623434 chr1 106623436 chr1 106623442 chr1 106623468 chr1 10699400 chr1 10699405 chr1 10699408 chr1 10699415 chr1 10699426 chr1 10699448 chr1 110611528 chr1 110611550 chr1 110611552 chr1 110611554 chr1 110611560

file 2

chr1 1066234 chr1 106994 chr1 1106115

i want search file 1 each line of file 2 , pull out every line has exact string , put new file. want each search output in own column or line separated tabs. want every line in file 2. output this:

chr1 106623434  chr1 10699400   chr1 110611528 chr1 106623436  chr1 10699405   chr1 110611550 chr1 106623442  chr1 10699408   chr1 110611552 chr1 106623468  chr1 10699415   chr1 110611554                 chr1 10699426   chr1 110611560                 chr1 10699448      

$ cat tst.awk nr==fnr { tgts[++numtgts] = $0; next } {     (tgtnr=1; tgtnr<=numtgts; tgtnr++) {         tgt = tgts[tgtnr]         if ($0 ~ "^"tgt) {             numhits[tgtnr]++             maxhits = (numhits[tgtnr] > maxhits ? numhits[tgtnr] : maxhits)             hits[tgtnr,numhits[tgtnr]] = $0         }     } } end {     (hitnr=1; hitnr<=maxhits; hitnr++) {         (tgtnr=1; tgtnr<=numtgts; tgtnr++) {              printf "%-16s%s", hits[tgtnr,hitnr], (tgtnr<numtgts?ofs:ors)         }     } }  $ awk -f tst.awk file2 file1 chr1 106623434   chr1 10699400    chr1 110611528 chr1 106623436   chr1 10699405    chr1 110611550 chr1 106623442   chr1 10699408    chr1 110611552 chr1 106623468   chr1 10699415    chr1 110611554                  chr1 10699426    chr1 110611560                  chr1 10699448

Comments

Post a Comment

Popular posts from this blog

1111. appearing after print sequence - php -

morning, i have code takes string of shoe sizes, explodes , puts in table. code works , info displayed correctly on page after table there few 1's after table. i'm confused this. so table looks (in columns of 3 on webpage) available in following sizes: 3 4 5 6 9 10 111 here's codes, purpose of example $x = 3|4|6|10|9 function get_sizes_pipe($x) { $counter = 0; $splits = explode("|",$x); asort($splits); $x = print "<table class='greentable'>"; $x .= print "<thead><tr><th scope='col' colspan='3' abbr='starter'>available in following sizes:</th></tr></thead><tbody><tr>"; foreach ($splits $split) { $entry = print "<td>".$split."</td>"; if($counter == 2){ $entry .= print "</tr><tr>"; $counter =0; } else { $counter++; ...
Read more

java - WARN : org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/board/] in DispatcherServlet with name 'appServlet' -

this question has answer here: why spring mvc respond 404 , report “no mapping found http request uri […] in dispatcherservlet”? 3 answers i trying making simple bbs i'm encountering following error, warn : org.springframework.web.servlet.pagenotfound - no mapping found http request uri [/board/] in dispatcherservlet name 'appservlet' i have tried solve error many times, have failed. how can solve error? here web.xml, controllerand , servlet-context. my web.xml <?xml version="1.0" encoding="utf-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <filter> <filter-nam...
Read more

Ruby on Rails, ActiveRecord, Postgres, UTF-8 and ASCII-8BIT encodings -

weirdest error, who’s challenge try , me? spent hours yesterday on , it’s magic. can't believe happening , it's driving me crazy. btw, using: rails 4.2.3 ruby 2.2.3 pg 0.18 encoding.default_internal = encoding.default_external = utf-8 config.encoding = 'utf-8' it has postgres, activerecord , encodings! turns out we’ve been getting these errors whenever create new users on database special characters: encoding::undefinedconversionerror: "\xc3" ascii-8bit utf-8 \xc3 may vary depending on characters. weird part we’ve set since beginning utf-8. makes no sense , digged it, , used script: user.all.each |user| user.attributes.each |name, value| if value.is_a? string puts user.email + name.encoding.to_s + value.encoding.to_s end end end and output of 1 of users, users same: dr_lottahelp@blahblah.comutf-8utf-8 dr_lottahelp@blahblah.comutf-8ascii-8bit dr_lottahelp@blahblah.comutf-8ascii-8bit dr_lottahelp@blahblah.comutf-8asci...
Read more