Adjust to suit your reqs:

#! perl -slw use strict; use Data::Dump qw[ pp ]; my %data; while( <DATA> ) { chomp; m{^ (.+) :: \s+ (.+) \s+ -- \s+ (.+) \s+ \[ (.+) \] \s* }x or warn "Mismatch: '$_'" and next; $data{ $1 } = { split( ' ', $2 ), split( ' ', $3 ), map { split '=', $_, 2 } split ',\s?', $4 }; $data{ $1 }{ Budget } = { map{ split '=' } split ';', $data{ $1 }{ Budget } }; } pp \%data;

Produces:

{ "01:00:00,00" => { Budget => { cost => 44_444, tax => "11%", total = +> 3343 }, Col => "Foo", Color => "y", Description => "Scene", International => "y", Link => "y", Sound => "Dolby", }, "02:00:00,00" => { Budget => { cost => 54_444, tax => "1%", total => + 1343 }, Col => "Boo", Color => "n", Description => "Scene", International => "y", Link => "y", Sound => "THX", }, "03:00:00,00" => { Budget => { cost => 64_444, tax => "1%", total => + 2343 }, Col => "Goo", Color => "y", Description => "Scene", International => "y", Link => "n", Sound => "PTX", }, "04:00:00,00" => { Budget => { cost => 84_444, tax => "1.1%", total +=> 5343 }, Col => "Aoo", Color => "n", Description => "Scene", International => "y", Link => "y", Sound => "DDY", }, }

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
"Too many [] have been sedated by an oppressive environment of political correctness and risk aversion."

In reply to Re: Trying to parse columns with different delimiters. by BrowserUk
in thread Trying to parse columns with different delimiters. by magawake

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.