http://qs321.pair.com?node_id=11124891


in reply to Re^2: match two files
in thread match two files

Please give a (small) dataset that shows that problem.

Replies are listed 'Best First'.
Re^4: match two files
by yueli711 (Sexton) on Dec 09, 2020 at 18:13 UTC
    Hello tybalt89, Thank you so much for your great help! The code is correct! A small question: How can 6 and 109521 separated with "Tab"? It looks they are separated with space. Thank you again and really appreciated! Best, Yue
    PeptideID ProteinID SpectrumID Sequence 6 109521 53663 KMGEGR 7 741 53663 KPPSGK 11 681 144492 NNDALR 11 780 144492 NNDALR 20 2352 15547 SPAKPK 27 1490 55547 LHKPPK 27 1491 55547 LHKPPK 27 1492 55547 LHKPPK 28 51996 55547 LFVGRK 29 1490 55504 LHKPPK 29 1491 55504 LHKPPK 29 1492 55504 LHKPPK 30 1490 55602 LHKPPK 30 1491 55602 LHKPPK 30 1492 55602 LHKPPK

      They should be separated by whatever is in your 'tmp01' file. Check your source file. Use  s/ +/\t/g if you want to convert spaces to a tab.