Actually, translate is not necessary, compress is enough:

name=compress(name,'0D'x);

> -----Original Message----- > From: Huang, Ya > Sent: Monday, December 13, 1999 12:32 PM > To: 'Micheal Quill'; SAS-L@LISTSERV.UGA.EDU > Subject: RE: Removing non - printable chars from fields > > > try translate and then compress: > > name=compress(translate(name,'','0D'x)); > > Ya Huang > Organon Inc. > > > -----Original Message----- > > From: Micheal Quill [mailto:michaelq@DEMON.NET] > > Sent: Monday, December 13, 1999 11:09 AM > > To: SAS-L@LISTSERV.UGA.EDU > > Subject: Removing non - printable chars from fields > > > > > > 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. > > >