Dear PerlMonks,

I have one file containing employee data that has been populated by different MySQL exported table files from one database.
How would I sort the data in this merged file to group together all relevant?
For example(the three dots signify x# of spaces between entries): 

Infile:
----------------
employee_id: 227
position_id: 182
departmentNumber: 38
id: 67
manager: 222
...

uid: SimpsonH
employee_id: 227
sn: Simpson
givenName: Homer
...

extension: 5555
employee_id: 227
telephonenumber: 218 344
fax: 0
phone_id: 652
...

position_id: 182
title: Nuclear Plant Operator
...

uid: BurnsM
employee_id: 222
sn: Burns
givenName: Montgomery Burns
...

name: Nuclear Resources
departmentNumber: 38
buildingName: 2
...

buildingName: 2
name: Radioactive Hall
...

buildingName: 2
roomNumber: 7
location_id: 6
...

roomNumber: 7
room: ControlTower


Outfile:
---------------------
uid: simpsonh
sn: Simpson
givenName: Homer
manager: burnsm
telephoneNumber: 2183445555
departmentNumber: 38
title: Nuclear Plant Operator
roomNumber: 7
buildingName: Nuclear Resources

[download]

I am not even sure where to start at this point. There is a pattern with the *_id categories that I could key in on and yank the following line but I'm unsure on how to go about doing that... please help!

Sincerely,

rycher

In reply to Open file, sort data on matching field, close file by rycher

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.