Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Logout splits long value names across many cells in Excel


From   Roy Wada <[email protected]>
To   [email protected]
Subject   Re: st: Logout splits long value names across many cells in Excel
Date   Wed, 14 Oct 2009 08:01:24 -0700

> is split across two cells with two columns bellow it, one with blanks
> and another one with the numbers. This is specially annoying when
> copying cells inside Excel.
>
> Is there any way to correct this behaviour?

The current help file says something about the need to let the user
manually apply infix.

A new option, fixcut( ) will handle this. The new version also comes
with range( ) option that is basically -chewfile- running from the
inside.

 -logout- will now display something like the following after every
fixed method so that if you don't like it then you can change the
numbers the next time around.

fixcut(11 16 27 38 45 50 67)

I should add that they should CONSECUTIVE NUMBERS.

The new version should be up on ssc.

Roy

    * The following three are equivalent:
    webuse dose, clear
    tab dose function, col
    chewfile using mylog.txt, begin(10) end(.) save(chewed.txt) replace
    logout, use(chewed.txt) clear fix
    logout, save(C:\mytable) tex excel replace

    webuse dose, clear
    logout, save(C:\mytable) tex excel replace range(10/.) fix: tab
dose function, col

    webuse dose, clear
    logout, save(C:\mytable) tex excel replace range(10/.) fixcut(11
16 27 38 45 50 67): tab dose function, col
*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index