Import text file

Hi

I've a large text file which I need to import selected information only.

Below is the sample text file which showing profile for 3 item. Any sample code or ideas would be appreciated.

Date: 25 Sep 09   2:58pm                                                                    Page:     1
Item Status Report

Items selected with the control account set (All account sets              ).
Sorted by item number from [                ] to [ZZZZZZZZZZZZZZZZ]

Item Number            Description

              47       LAMP                                    
 Category           [CON]     Tax status  [0]        Markup factor  [  1.00 ]        Last shipment [         ]
 Picking sequence   [    ]    Stock item  [Y]        Serial numbers [0]              Last receipt  [07 Mar 08]
 Report group       [   ]     Unit weight [          0.00 ]           
 Avg.days between ship.[             0 ]     Average units shipped [          0.00 ] EA        
 -- Cost per EA         -------------- Previous cost ---- Date of change -------------------------------------
 Standard cost      [          0.00 ]  [          0.00 ]  [29/11/05]              Cost 1     [          0.00 ]
 Most recent cost   [          0.47 ]  [          0.00 ]  [07/03/08]              Cost 2     [          0.00 ]
 Account set        (Consumables                   )  
 Costing method     (Moving average )                 
 Total cost         [         23.50 ]                 
 Average unit cost  [          0.47 ] EA              
 -- Units of measure -----------------------------------------------------------------------------------------
 Stocking unit      [EA        ]    Pricing unit: (EA        )    Costing unit: (EA        )
 Alternate units    [          ]         [          ]         [          ]         [          ]         
 Conversion factors [        1.0000 ]    [        1.0000 ]    [        1.0000 ]    [        1.0000 ]    
 -- Total quantities ---- Qty on hand ------ Qty on P/O ------ Qty on S/O ------------------------------------
          50.00              0.00              0.00  EA        
 -- Additional item information ------------------------------------------------------------------------------
 [K5501    ]
 [MS15571-2]
 [         ]
 [         ]

              63       BULB              
 Category           [CON]     Tax status  [0]        Markup factor  [  1.00 ]        Last shipment [         ]
 Picking sequence   [    ]    Stock item  [Y]        Serial numbers [0]              Last receipt  [         ]
 Report group       [   ]     Unit weight [          0.00 ]           
 Avg.days between ship.[             0 ]     Average units shipped [          0.00 ] EA        
 
Date: 25 Sep 09   2:58pm  Page:     2
Item Status Report

Sorted by item number from [                ] to [ZZZZZZZZZZZZZZZZ]

Item Number            Description

              63       BULB              
 -- Cost per EA         -------------- Previous cost ---- Date of change -------------------------------------
 Standard cost      [          0.00 ]  [          0.00 ]  [  /  /  ]              Cost 1     [          0.00 ]
 Most recent cost   [          2.15 ]  [          0.00 ]  [  /  /  ]              Cost 2     [          0.00 ]
 Account set        (Consumables                   )  
 Costing method     (Moving average )                 
 Total cost         [          0.00 ]                 
 Average unit cost  [          0.00 ] EA              
 -- Units of measure -----------------------------------------------------------------------------------------
 Stocking unit      [EA        ]    Pricing unit: (EA        )    Costing unit: (EA        )
 Alternate units    [          ]         [          ]         [          ]         [          ]         
 Conversion factors [        1.0000 ]    [        1.0000 ]    [        1.0000 ]    [        1.0000 ]    
 -- Total quantities ---- Qty on hand ------ Qty on P/O ------ Qty on S/O ------------------------------------
           0.00              0.00              0.00  EA        
 -- Additional item information ------------------------------------------------------------------------------
 [K5504    ]
 [MS15570-63                     ]
 [F0N9-4101-1                    ]
 [         ]

              C4       CORE              
 Category           [CON]     Tax status  [0]        Markup factor  [  1.00 ]        Last shipment [26 Jul 04]
 Picking sequence   [    ]    Stock item  [Y]        Serial numbers [0]              Last receipt  [31 Dec 02]
 Report group       [   ]     Unit weight [          0.00 ]           
 Avg.days between ship.[           159 ]     Average units shipped [          5.00 ] EA        
 -- Cost per EA         -------------- Previous cost ---- Date of change -------------------------------------
 Standard cost      [          0.00 ]  [          0.00 ]  [  /  /  ]              Cost 1     [          0.00 ]
 Most recent cost   [          2.54 ]  [          0.00 ]  [  /  /  ]              Cost 2     [          0.00 ]
 Account set        (Consumables                   )  
 Costing method     (Moving average )                 
 Total cost         [          0.00 ]                 
 Average unit cost  [          0.00 ] EA              
 -- Units of measure -----------------------------------------------------------------------------------------
 Stocking unit      [EA        ]    Pricing unit: (EA        )    Costing unit: (EA        )
 Alternate units    [          ]         [          ]         [          ]         [          ]         
 Conversion factors [        1.0000 ]    [        1.0000 ]    [        1.0000 ]    [        1.0000 ]    
 
Date: 25 Sep 09   2:58pm  Page:     3
Item Status Report

Sorted by item number from [                ] to [ZZZZZZZZZZZZZZZZ]

Item Number            Description

              C4       CORE              
 -- Total quantities ---- Qty on hand ------ Qty on P/O ------ Qty on S/O ------------------------------------
           0.00              0.00              0.00  EA        
 -- Additional item information ------------------------------------------------------------------------------
 [OBS      ]
 [         ]
 [         ]
 [         ]

              R1       STRAP             
 Category           [CON]     Tax status  [0]        Markup factor  [  1.00 ]        Last shipment [         ]
 Picking sequence   [    ]    Stock item  [Y]        Serial numbers [0]              Last receipt  [31 Dec 02]
 Report group       [   ]     Unit weight [          0.00 ]           
 Avg.days between ship.[             0 ]     Average units shipped [          0.00 ] EA        
 -- Cost per EA         -------------- Previous cost ---- Date of change -------------------------------------
 Standard cost      [          0.00 ]  [          0.00 ]  [  /  /  ]              Cost 1     [          0.00 ]
 Most recent cost   [         12.06 ]  [          0.00 ]  [  /  /  ]              Cost 2     [          0.00 ]
 Account set        (Consumables                   )  
 Costing method     (Moving average )                 
 Total cost         [          0.00 ]                 
 Average unit cost  [          0.00 ] EA              
 -- Units of measure -----------------------------------------------------------------------------------------
 Stocking unit      [EA        ]    Pricing unit: (EA        )    Costing unit: (EA        )
 Alternate units    [          ]         [          ]         [          ]         [          ]         
 Conversion factors [        1.0000 ]    [        1.0000 ]    [        1.0000 ]    [        1.0000 ]    
 -- Total quantities ---- Qty on hand ------ Qty on P/O ------ Qty on S/O ------------------------------------
           0.00              0.00              0.00  EA        
 -- Additional item information ------------------------------------------------------------------------------
 [6501 Hangar                    ]
 [         ]
 [         ]
 [         ]