Hi Monks,
i have the following data

12;22533721
12;18217115
12;23517705
12;28196422
12;26247514
12;26235466
12;26461322
12;23653293
12;18850798
12;23694918
12;28544046
12;26668890
12;26501989
12;26192004
12;23331033
12;19781377
12;25114470
12;28433017
12;27228379
12;27381735
12;27235837
12;25695918
12;25776071
12;21933659
12;19778625
12;18136550
12;23172711
12;23192154
12;21052533
12;20162237
12;19371167
01;33723276
01;27077592
01;25222950
01;24774003
01;22267932
01;19688033
01;23363461
01;27152096
01;25984687
01;24855444
01;26059561
01;22790798
01;18620768
01;22862582
01;25991422
01;25314897
01;24899719
01;31966695
01;25828569
01;18532027
01;22411384

[download]

and i want somthing like this
01;18532027;18532027;...
12;28532027;18532027...

[download]

so that all values with 01 stand behind each other.

i want to use a HoA because i've done it lots of times before but at the moment im stuck with this.
any tips and hints will be usefull because im now thinking of this for about 1 hour

kd ultibuzz

In reply to Simple Table structure to file by ultibuzz

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.