Unconfigured Ad

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • Liy
    Member
    • Feb 2012
    • 19

    text file editing

    Dear all,

    I have a problem that i cannot solve and I hope someone here can help me.

    I have two text files with one column of values.
    Example:

    File1:
    67
    94
    95
    .
    .

    File2
    0.1
    0.003
    0.5
    .
    .

    File1 contains the row numbers that value I need from File2. For example the output should be like this:

    Theoretical outfile:
    0.4 (row 67 from File2)
    0.5 (row 94 from File2)
    0.1 (row 95 from File2)
    etc...

    Is it possible to do this with awk?

    I would really appritiate if someone can help me.

    Thanks,
    Liy
  • Liy
    Member
    • Feb 2012
    • 19

    #2
    solved

    awk 'FNR==NR{A[NR]=$0;next} ($0 in A){print A[$0]}' file2 file1

    Comment

    Latest Articles

    Collapse

    • GATTACAT
      Reply to Nine Things a Sample Prep Scientist Thinks About Before Sequencing
      by GATTACAT
      Love this - good data definitely starts from good input, and poor input can only give relatively poor data. I particularly like the mention of Nanodrop/absorbance based methods for quantification. It's such a toss up if you'll get an accurate reading or what amounts to a randomly generated number, and a lot of library/sequencing related issues can be traced back to poor quant.
      07-01-2026, 11:43 AM
    • SEQadmin2
      Nine Things a Sample Prep Scientist Thinks About Before Sequencing
      by SEQadmin2


      I’m not a sequencing expert. I’m a purification scientist who uses NGS to evaluate workflows my group develops. With this perspective, we think about the sample first and the NGS workflow second. The sequencer is an exceptionally honest reporter, but it can only report on what you give it, so whether you get clean, interpretable data from an NGS workflow is largely determined before you begin.

      Here are nine questions we think about, in roughly the order they matter, before...
      06-18-2026, 07:11 AM

    ad_right_rmr

    Collapse

    News

    Collapse

    Topics Statistics Last Post
    Started by SEQadmin2, 07-02-2026, 11:08 AM
    0 responses
    19 views
    0 reactions
    Last Post SEQadmin2  
    Started by SEQadmin2, 06-30-2026, 05:37 AM
    0 responses
    20 views
    0 reactions
    Last Post SEQadmin2  
    Started by SEQadmin2, 06-26-2026, 11:10 AM
    0 responses
    21 views
    0 reactions
    Last Post SEQadmin2  
    Started by SEQadmin2, 06-17-2026, 06:09 AM
    0 responses
    54 views
    0 reactions
    Last Post SEQadmin2  
    Working...