st: Re: problem with split command

["Joseph Coveney" <jcoveney@bigplanet.com>]

Forgot to mention:  for this year's survey and afterward, try the alternative below.  You can use Stata's regular expressions, too.

Joseph Coveney


. input str30 state_name

                         state_name
  1. "Andhra2012"
  2. "Arunachal2012"
  3. "Assam2012"
  4. "Bihar2012"
  5. "UttarPradesh2012"
  6. end

. 
. generate byte first_numeral = indexnot(state_name, "`c(alpha)'`c(ALPHA)'")

. generate long year = real(substr(state_name, first_numeral, .))

. replace state_name = substr(state_name, 1, first_numeral - 1)
(5 real changes made)

. 
. list, noobs separator(0) abbreviate(20)

  +-------------------------------------+
  |   state_name   first_numeral   year |
  |-------------------------------------|
  |       Andhra               7   2012 |
  |    Arunachal              10   2012 |
  |        Assam               6   2012 |
  |        Bihar               6   2012 |
  | UttarPradesh              13   2012 |
  +-------------------------------------+

. 
. exit

end of do-file



*
*   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/