Date:         Thu, 5 Mar 2009 10:49:29 -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

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