hopefully this looks better I apologize for not clarifying what the data looks like before hand, below is a larger sample of the data with each data line placed after number sign
As you can see the data dump is pretty sloppy and that is why I need perl to clean it up.
Thanks again
instrument_name # Header
#LOCAL CURRENCY#
#FOREIGN CURRENCY#
#144A Promissory Note Program
#3(A)3 CP prog
#3(A)3 CP prog auth amt CAD1 bil
#3(A)3 CP prog auth amt US$14 bil
#4(2) CP prog auth amt US$300 mil
#4(2) CP prog auth amt US$5 bil
#4(2) CP prog auth amt US$6 bil
#4(2) Extendable CP prog auth amt US$2 bil
#4(2) Extendible Commerical Notes prog
#CANADIAN CP prog auth amt CAD0 mil
#CANADIAN CP prog auth amt CAD0 mil
#CP prog Rule 144A
#EURO 5 bil CP prog
#Euro CP prog auth amt US$0 mil
#"MAJOR" multi-jurisdiction repackaging note programme #US$30 million class A secured floating rate credit-linked notes due 2010
#"MAJOR" multi-jurisdiction repackaging note programme ¥3 billion class A secured floating rate credit-linked notes due 2010
#"MAJOR" multi-jurisdiction repackaging note programme ¥4 billion class A secured fixed rate credit-linked notes due 2012
#AUD190 mil 6.38% nts due 10/21/2011
#AUD400 mil fltg rate nts due 10/21/2009
#AUD410 mil 6.195% nts due 10/21/2009
#Archstone I PLC
#Asgodia CDO Ltd. US$80M CLN (Private & Confidentia Channel CDO, Limited
#Checkers: US$195 million credit default swap (no liability issued)
#Classes A-C Credit Linked Notes due 2008
#EUR 471.15 million floating-rate notes
#EUR 471.15 million floating-rate notes
#EUR 50 million credit default swap portfolio A, series 2003-3/4
#EUR 633.20 million asset-backed floating-rate notes
#EUR 72 million floating rate notes
#EUR 72 million floating rate notes
#EUR Class C fixed spread coupon credit-linked notes series 2004-17 (Up to EUR5 billion programme)
#EUR Class C floating spread coupon credit-linked notes series 2004-18 (Up to EUR5 billion programme)

In reply to Re^2: Using perl to break up sentences in rows into Separate columns by mariah
in thread Using perl to break up sentences in rows into Separate columns by mariah

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.