ok here is the first part of the text file. i need to extract the date from this 

From: g027778@msx.stp.guidant.com
Sent: Thursday, September 03, 2009 08:33
To: Steidl, Charles (STP); Gubbins, John (CLN); Horan, Laurence (CLN);
Duppong, Lawrence (STP); Donovan, Leighton (CLN); Deasy, Luke (CLN);
Walmsley, Mark (STP); Smith, Noel (CLN); Keating, Patrick (CLN); Doyle
+,
PJ (CLN); Heineman, Scott (STP); Maher, Stephen (CLN); Williams, Thoma
+s
(STP)(Test Eng); Nguyen, Thuan (STP)
Subject: ** Summary of yield for Product: Insignia__Hyb_E1

****  Yield Report  ****

****  Product Name        : Insignia__Hyb_E1_581394
****  Software Product    : 581394-201-A
****  Test Level          : Hyb_E1
****  Part Number         : 401666-312
****  Model Number        : h666
****  RMI DataBase        : prod
****  Analysis Date Range : 09/02/2009 00:00:00 to 09/02/2009 23:59:59
****  Tested First/Last   : 09/02/2009 02:06:04 to 09/02/2009 19:20:16

[download]
After analysis date range i need to take out the 09/02/2009. this date will change every day so searching for it will not work. i'm trying to use an array to fins analysis date range and then take the next 'x' amount of characters and output them to the excel file. this would be the first step. what i'm comming up with is that I can find the analysis date range but my array etc is not working. And yes I as dropped royally in it given this 2 weeks ago and i'm finishing work next week. only an intern here for the summer. electrical engineer undergraduate and we don't do this sort of stuff often/ever. thanks a mil for all the help though. and I have it broken down. above is the first part!

In reply to Re^2: Gettin certain lines of text from a text file! by Foxyirish1987
in thread Gettin certain lines of text from a text file! by Foxyirish1987

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.