|Date: ||Mon, 13 Dec 1999 17:37:40 GMT|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|Organization: ||Deja.com - Before you buy.|
|Subject: ||Re: Removing non - printable chars from fields|
I swear I'll never understand -
10 seconds' worth of experimentation reveals that the COMPRESS function
accepts hexadecimal codes.
In article <email@example.com>,
firstname.lastname@example.org (Micheal Quill) wrote:
> I have loaded in a text file into a table and when I use view table to
> look at the table I have the following situation.
> Name Age
> joe-blogs 12
> joe-blogs| 12
> Now the likely culprit is the original text files were current.
> However I don't really want to go back and find the original files if
> I can avoid it . The originals are 30 gzip's that are 1 gig each
> Using a HEX editor on the SAS data files we get the following
> 2D 31 20
> 2D 31 0D
> Ignore the 2D 31 part, these are codes for the ASCII characters. So it
> looks like I have Carriage Return slapped in the middle of a record.
> Any ideas ? Does the compress function accept Hexadecimal codes ?
> How do I select records where one field contain's CR or 0D Hex?
> I am running Ver 8 under NT.
Sent via Deja.com http://www.deja.com/
Before you buy.