Hey I have to add something.
This time I use the data file in excel, save it as xml , now I copy
and paste from XML to Stata and VOILA! the annoying spaces are GONE!!!
Any tips / words of wisdom ?
Thank you,
Ashim
On Fri, Oct 3, 2008 at 4:09 PM, Ashim Kapoor <[email protected]> wrote:
> 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/
