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