Try this code to see if it is what you are looking for.

#!/usr/bin/perl -w my $data = 'reference.txt'; open INFILE, '<', $data; my %hash = (); while (<INFILE>) { chomp($_); my ($id,$description)=split(/\t/); #print $id,' << ',$description,"\n"; $hash{ $id } = $description; } #print "\n"; #while ( my ($key, $value) = each(%hash) ) { # print "$key => $value\n"; # } my $data2 = "readthisfile.txt"; open INFILE2, "<", $data2; while(<INFILE2>) { chomp($_); @parts = split /\t/; print "Original \t",++$i,': ',$_,"\n"; print "Replaced \t",$i,': '; foreach $parl(@parts){ if ($parl =~ m/(.*\{)([0-9]+)(\}.*)/) { $parl = $1.$hash{$2}.$3 if exists $hash{$2}; } print $parl,"\t"; } print "\n"; }
perl "D:\Temp\repalce1.pl" Process started >>> Original 1: ABCDE Replaced 1: ABCDE Original 2: + + Replaced 2: Original 3: +P237S S{301609239} + + + Replaced 3: +P237S S{kitchen} Original 4: +R372W W{114672573} + + + Replaced 4: +R372W W{study room} Original 5: +K576R R{20531742} R{89242146} + + + Replaced 5: +K576R R{living room} R{terrace} Original 6: +R1059Q Q{126723431} Q{6934272} Replaced 6: +R1059Q Q{126723431} Q{6934272} Original 7: Replaced 7: Original 8: STRKE Replaced 8: STRKE Original 9: Replaced 9: Original 10: +T216I I{301781720} I{148237434} + + + Replaced 10: +T216I I{balcony} I{148237434} Original 11: +V275I I{149632297} I{47224534} + + + Replaced 11: +V275I I{149632297} I{47224534} Original 12: +R13H H{126333615} + + + Replaced 12: +R13H H{126333615} Original 13: +F113L L{301781720} L{148237434} + + + Replaced 13: +F113L L{balcony} L{148237434} Original 14: +G135S S{147902132} S{47224534} S{125864042} + S{107921834} + + Replaced 14: +G135S S{147902132} S{47224534} S{125864042} + S{107921834} Original 15: +T307A A{224050516} A{126333615} + + + Replaced 15: +T307A A{224050516} A{126333615} Original 16: +L217F F{149632297} F{147902132} Replaced 16: +L217F F{149632297} F{147902132} <<< Process finished. ================ READY ================

In reply to Re: Search & Replace Across Two Files by Generoso
in thread 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.