LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2000, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page