Hello,
I posted about this a couple of days ago.
Let me tell you my problem. I have a string variable , sometimes 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
doing an itrim. But some observations continue to have 2 spaces
between the 2nd last and last word. Nothing seems to be working!
Any tips ?
Thank you,
Ashim.
On Wed, Oct 1, 2008 at 7:53 PM, Ashim Kapoor <[email protected]> wrote:
> Thank you. I will try that and get back to you.
>
> Ashim.
>
> On Wed, Oct 1, 2008 at 7:31 PM, Johannes Geyer <[email protected]> wrote:
>>> That is a solution for Stata->Excel, but Ashim asked about Excel->Stata.
>> I
>>> tried to replicate his problem, and it did not happen to me... Anything
>>> special about that string variable that we should know about, Ashim?
>> Have
>>> you tried to -insheet- instead of pasting?
>>
>>
>> Right! I missed that. I would try - insheet- as Martin suggests; -odbc-
>> may also help
>>
>> h odbc
>>
>> Johannes
>>
>>
>>
>>
>>
>>>
>>> -----Original Message-----
>>> From: [email protected]
>>> [mailto:[email protected]] On Behalf Of Johannes
>> Geyer
>>> Sent: Wednesday, October 01, 2008 3:41 PM
>>> To: [email protected]
>>> Subject: Re: st: space trouble in excel to stata conversion
>>>
>>> "here is what I do, I copy and paste a string variable from excel to
>>> stata ( ie. a column of observations from excel to stata). For some
>>> strange reason there is a SPACE after each observation which refuses
>>> to go away even after I use the -trim- command.
>>> Has anyone experienced this ? Please tell me if I can read about this
>>> somewhere."
>>>
>>> I don't know - you could do the following and avoid that problem:
>>>
>>> *********************
>>> sysuse auto
>>> xmlsave make using FILENAME, replace doctype(excel)
>>> *********************
>>>
>>> Johannes
>>>
>>>
>>>
>>>
>>> ----------------------
>>> Johannes Geyer
>>> Deutsches Institut f�r Wirtschaftsforschung (DIW Berlin)
>>> German Institute for Economic Research
>>> Department of Public Economics
>>> DIW Berlin
>>> Mohrenstra�e 58
>>> 10117 Berlin
>>> Tel: +49-30-89789-258
>>>
>>>
>>>
>>>
>>>
>>> *
>>> * 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/
>>>
>>>
>>> *
>>> * 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/
>>
>>
>> *
>> * 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/
>>
>
*
* 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/
