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 (March 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 5 Mar 2009 10:59:03 -0800
Reply-To:     biggiefish <esther.fu@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         biggiefish <esther.fu@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Tab-delimited problem, "extra space between each character"
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Encoding = "unicode" fixed all my problems! Thank you so much peter!!

On Mar 5, 1:49 pm, biggiefish <esther...@gmail.com> wrote: > I don't think it's a DBCS issue, but the data is coming in from a > Siebel system. Not sure if that has anything to do with it. > > I tried the hex suggestion: here is what I got for 10 observations: > > put var $hex50.; > > 00220048006900610077006100740068006100200042007200 > 002200530069006F00750078006C0061006E00640020005500 > 00220053006300680061006500660065007200200047007200 > 0022004E0065007700200048006F0070006500200056006900 > 00220055006E00690074006500630068002000500072006500 > > I'm not sure what it means, or what it has in between the > characters... > > The original text is supposed to be: > > Hiawatha Broadband Communications Inc PRCB 26L000009AWQ > Siouxland Urology Assoc PRCB 26L000009AYH > Schaefer Greenhouses Inc PRCB 26L000009QL1 > New Hope Village Inc PRCB 26L000009RTZ > Unitech Prepress Solutions Inc PRCB 26L000009VSY > > Thanks, > Esther > > On Mar 5, 12:48 pm, snoopy...@GMAIL.COM (Joe Matise) wrote: > > > Sounds like it might be a DBCS (double byte character) file, being read in > > as a single byte character [the second byte being transformed to a space, as > > it's a nonprintable character], perhaps? Is it a file from an asian > > language system, perhaps? > > -Joe > > > On Thu, Mar 5, 2009 at 11:30 AM, biggiefish <esther...@gmail.com> wrote: > > > Hi, > > > Has anyone encountered a problem where after you import a tab- > > > delimited file, there is an extra quote in each field, as well as > > > extra space inserted between each character, like this, > > > > " O u t b o u n d T e l e p r o s p e c t i n g " > > > > instead of > > > > Outbound Teleprospecting > > > > Any help would be greatly appreciated. Thank you so much in advance!! > > > > Esther


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