Oh wise ones... My situation is this - I have a text file that is stored in a name / value format that looks something like this:

Company: ABC Trucking
Contact: Joe Smith
Title: President
etc...

I want to convert it to a pipe delimited file, or something similar. The problem is that each record does not have the same # of fields (for example, one may have just Company and Title). I am looking for a way to read through the file, separate each field with some special character and if the record does have one of the fields (from the know full list of fields) append a space to the field. Please let me know if anyone can point me to any examples or sources of information that can help me solve my problem. Thanks a bunch!

In reply to Newbie Trying to Read and Reformat File by tbfive

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.