Date: Fri, 11 Feb 2000 09:47:41 -0500
Reply-To: smg1get@njcmail.ups.com
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gary Tiedens <smg1get@NJCMAIL.UPS.COM>
Subject: Pulling data
Content-Type: text/plain; charset="iso-8859-1"
Hello all,
I am trying to read a file and pick off records in 2 fields
700007 00080000 00014946 019 FULL YES *NONE*
700128 00080000 00110629 100 FULL YES 876292
R82820 04000000 02344657 059 FULL YES R80700
I need the 1st 6 bytes and the last 6 bytes, but as you can see I have
different characters in the last position, and they fluctuate between
numeric and character. What I need to do is strip out all of the character
data(*none* for example). And leave only the 1st 6 digits and anything that
starts with a letter followed ny numeric characters. (In the example above
this would be R80700 or R82820)
Gary
|