This may not be a popular solution, but if your files are a decent size you could use a hash.

Read each line of the data file and split on the first tab. Turn this into a hash with the ID as the key and the remaining of the line as the data for the hash. (You could also use a hash of arrays)

Now you can load the update file, line by line.
Turn the line into an array.
Use the first array entry as the hash key to get the hash data.
Create the new hash data string from the update data.
Update the Data Hash.
Read next line from update file.

You end up with an updated hash. Now print that back to the file.

In reply to Re^3: flat file databases by Zero_Flop
in thread flat file databases by Travis M.

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.