I swear I'll never understand -

10 seconds' worth of experimentation reveals that the COMPRESS function accepts hexadecimal codes.

In article <38551334.3985979655@news.demon.co.uk>, michaelq@demon.net (Micheal Quill) wrote: > Hi, > 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 > uncompressed. > > 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. > > TIA. > >

Sent via Deja.com http://www.deja.com/ Before you buy.