If I understood your post correctly, here's one way: 
#!c:\perl\bin\perl -w

use strict;

my $currentheading;
my %hash;
my @headings;
my @array;

open(FILE,"c:\\test.txt");
while(my $line = <FILE>)
{
    chomp($line);
    if($line =~ /(.*?:)$/)
    {
        $currentheading = $1;
        push @headings, $currentheading;
    }
    else
    {
        push @{$hash{$currentheading}}, $line;
    }
}

for my $x(0..$#headings)
{
    my $record = 0;
    for my $y(0..$#{$hash{$headings[$x]}})
    {
        $array[$record][$x] = $hash{$headings[$x]}[$y];
        $record++;
    }
}

my $header = join ",",@headings;
print "$header\n";
for my $x(0..$#array)
{
    my $recordline = join ",", @{$array[$x]};
    print "$recordline\n";
}

[download]
This will handle missing fields in certain records. Perl will issue a warning however if a field is missing.

Note: I removed the newlines to show the data in an easily readable format. To keep them just remove the line: chomp($line);

Update:looks like pbeckingham beat me to a similar solution.

In reply to Re: Textfile to csv with a small twist by ChrisR
in thread Textfile to csv with a small twist by Bentov

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.