uugh. Sorry for the missing/inconsistent info.

Let me try again...

I have a directory 1000 text files with names as follows... 

...
barnyard.chiq
beach_bum.chiq
belly.chiq
belly.chiq.20040413103234
belly.chiq.20040417092739
belly.chiq.20040417093935 # <-- Last created file  
berry.chiq
bert.chiq
...

[download]
If you opened any of files (for example belly above), it would look like this: 
{*JohnDoe* (Saturday, April 10, 2004, 10:41):
Belly is a term used to describe a rounded surfboard bottom, when view
+ed from the front or rear (not from the side).
}

[download]
What I'm looking to do is convert & import the last created file for each record into one big .csv file. Each record needs to map to the csv as follows (still using belly): 
Belly, JohnDoe, 1081593660, "Belly is a term used to describe a rounde
+d surfboard bottom, when viewed from the front or rear (not from the 
+side)."

[download]
Notes: First column in csv is the title of the file minus the extension. Ideally filenames like "beach_bum" can be converted to "Beach Bum." Third column in csv is date converted to unix timestamp. Fourth column is content b/w the : and the last } -- this text block can have any type of character in it, including quotes, commas, etc.

Again, sorry for the laim first post -- and my $50 contrib to Perl Monks stands...

In reply to Re^2: complex text file to csv by mpaler
in thread complex text file to csv by mpaler

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.