Date:         Tue, 17 Mar 2009 10:45:38 -0400
Reply-To:     Nathaniel.Wooding@DOM.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nat Wooding <Nathaniel.Wooding@DOM.COM>
Subject:      Re: Extract word from a line in the raw data file
In-Reply-To:  <200903171421.n2HAmW37026048@malibu.cc.uga.edu>
Content-Type: text/plain; charset="US-ASCII"

OK, if they do not always start in the same place, do the filenames always
contain only letters? If so, then

dsn = compress( line , ':' , 'd' );

removes the colon and all numbers. If you are running V8, it would be

dsn = compress( line , ':0123456789'   );

Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977



             Abc Unha
             <abcunha@YAHOO.CO
             M>                                                         To
             Sent by: "SAS(r)          SAS-L@LISTSERV.UGA.EDU
             Discussion"                                                cc
             <SAS-L@LISTSERV.U
             GA.EDU>                                               Subject
                                       Re: Extract word from a line in the
                                       raw data file
             03/17/2009 10:21
             AM


             Please respond to
                 Abc Unha
             <abcunha@YAHOO.CO
                    M>






The issue it does not start at 28 everytime. It varies almost everytime.
Only unique value to identify line is libref i.e. abc abcdef and dataabc.
I can get full line but need to extract only table name.
so for e.g. from below good lines. I only need "ABC.ADDRESS_RAWDATA"
or "DATAABC.WHATEVER_RAWDATA"

20090913:10:23:36: 00000002 FROM ABC.ADDRESS_RAWDATA AS ADDRESS_RAWDATA
20090913:10:23:36: 0000000002 IOM LOG (73,20):111 FROM
DATAABC.WHATEVER_RAWDATA AS WHATEVER_RAWDATA


CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.