Date:         Thu, 5 Mar 2009 13:30:25 -0600
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Tab-delimited problem, "extra space between each character"
Comments: To: biggiefish <esther.fu@GMAIL.COM>
Content-Type: text/plain; charset="iso-8859-1"

It is a hex binary 0 between each of the chararacters; which
is an unprintable character that is more like a "null"; it looks like you've
got it solved with unicode, but perhaps the compress function could get
those out of there if that doesn't work.   When I used to do client-server
programming things would really choke on hex binary 0's.

-Mary
  ----- Original Message ----- 
  From: biggiefish 
  To: SAS-L@LISTSERV.UGA.EDU 
  Sent: Thursday, March 05, 2009 12:49 PM
  Subject: Re: Tab-delimited problem, "extra space between each character"


  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