Use a hash.

And please format your sample files so others can easily read them. There's more than one way to do it, but personally I would just paste my files between code tags and then make sure the line breaks are where they belong.

Here's an example of what I mean:

file1.txt 
---------
barra_id,cusip,tickers 
CAN1234,00234q,ABH.C
CAN3245,0129ab,BCHD

[download]
etc.

Then use the preview button and think about how the display will look to others. Help others see what your data looks like, and somebody may feel like offering more detailed advice.

In reply to Re: compare:file records by Narveson
in thread compare:file records by roc

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.