Hi all,

I am stuck with this search&replace problem and would appreciate your help.

What I would like to do is to find the ids in a file and replace them with their descriptions provided in another text file.

Here is the reference file - tab-delimited

301609239    kitchen
114672573 study room
20531742    living room
89242146    terrace
301781720    balcony

[download]

And here is the file to be read and in which the replacements to be included

ABCDE
                                                                      
+                                                                     
+                                     
+P237S    S{301609239}                                                
+                                                                     
+                                                                     
+          
+R372W    W{114672573}                                                
+                                                                     
+                                                                     
+          
+K576R    R{20531742}    R{89242146}                                  
+                                                                     
+                                                                     
+                    
+R1059Q    Q{126723431}    Q{6934272}    

STRKE

+T216I    I{301781720}    I{148237434}                                
+                                                                     
+                                                                     
+                      
+V275I    I{149632297}    I{47224534}                                 
+                                                                     
+                                                                     
+                     
+R13H    H{126333615}                                                 
+                                                                     
+                                                                     
+         
+F113L    L{301781720}    L{148237434}                                
+                                                                     
+                                                                     
+                      
+G135S    S{147902132}    S{47224534}    S{125864042}    S{107921834} 
+                                                                     
+                                                                     
+                                             
+T307A    A{224050516}    A{126333615}                                
+                                                                     
+                                                                     
+                      
+L217F    F{149632297}    F{147902132}

[download]

The desired output would look like this:

ABCDE
                                                                      
+                                                                     
+                                     
+P237S    S{kitchen}                                                  
+                                                                     
+                                                                     
+        
+R372W    W{study room}                                               
+                                                                     
+                                                                     
+           
+K576R    R{living room}    R{terrace}                                
+                                                                     
+                                                                     
+                      
+R1059Q    Q{126723431}    Q{6934272}    

STRKE

+T216I    I{balcony}    I{148237434}                                  
+                                                                     
+                                                                     
+                    
+V275I    I{149632297}    I{47224534}                                 
+                                                                     
+                                                                     
+                     
+R13H    H{126333615}                                                 
+                                                                     
+                                                                     
+         
+F113L    L{301781720}    L{148237434}                                
+                                                                     
+                                                                     
+                      
+G135S    S{147902132}    S{47224534}    S{125864042}    S{107921834} 
+                                                                     
+                                                                     
+                                             
+T307A    A{224050516}    A{126333615}                                
+                                                                     
+                                                                     
+                      
+L217F    F{149632297}    F{147902132}

[download]

And here is the script that I wrote but it does not work - not even generating error 

#!/usr/bin/perl -w

my $data = 'reference.txt'; 
open INFILE, '<', $data;

while(<INFILE>)
{
   
   my $line = $_;
   
   chomp($line);
   
    my ($id, $description) = split /\t/, $line, 2;
    
    my $data2 = "readthisfile.txt";
    open INFILE2, "<", $data2;

    while(<INFILE2>) {

                    my $line2 = $_;
                    
                    chomp($line2);
    
                    $line2 =~ s/$id/$description/g;
                        
                    }
}

[download]

In reply to Search & Replace Across Two Files by sophix

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.