Re^2: Using perl to break up sentences in rows into Separate columns

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)

Comment on Re^2: Using perl to break up sentences in rows into Separate columns

Replies are listed 'Best First'.
Re^3: Using perl to break up sentences in rows into Separate columns by shemp (Deacon) on May 10, 2005 at 16:56 UTC
Ok, well thats a much larger data sample, but most of those lines in no way fit into your original problem, which means that your original specification of what you want done with it no longer applies. I also deal with a lot of quite poorly formatted data, and the one thing that you really need to pin down is exactly what you want done with the data.	[reply]