Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: space trouble in excel to stata conversion


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: space trouble in excel to stata conversion
Date   Fri, 3 Oct 2008 19:00:43 +0100

In addition to much good advice, it may be that these spaces are not
really spaces at all, but some exotic character. 

-charlist- from SSC is one tool here. Look for things that look like
spaces but are not char(32). 

Alternatively, use -hexdump- on the data file. 

Nick 
n.j.cox@durham.ac.uk 

Ashim Kapoor [edited heavily] 

I have a string variable. 

At the end of many observations I seem to have an extra space character
which does not go away when I use -trim()-.

Also I have tried adding a " dummy" to all the observations and then
using -itrim()-. But some observations continue to have two spaces
between the second last and last word. 

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index