Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Splitting a string variable


From   "Jamie Griffin" <Jamie.Griffin@lshtm.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Splitting a string variable
Date   Tue, 06 Sep 2005 21:41:58 +0100

To remove leading zeros from the string variable x without looping, how
about:

replace x=substr(x, indexnot(x, "0"), . )

Jamie Griffin


>>> n.j.cox@durham.ac.uk 09/06/05 7:27 pm >>>
This is not really a splitting problem,
at least not sensu -split-.

To remove leading zeros, I would do this:

quietly {
	count if substr(myvar,1,1) == "0"
	while `r(N)' {
		replace myvar = substr(myvar,2,.) ///
		        if substr(myvar,1,1) == "0"
		count if substr(myvar,1,1) == "0"
	}
}

Any solutions without looping?

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

 >>> Raphael Fraser

I have a string variable of the type listed below:

id
0008
0020
016A
0160C

How do I remove the leading zeros from this variable? I tried using
the -split- command, but it removed both leading and trailing zeros.
The end result should look like this:

id
8
20
16A
160C
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html 
*   http://www.stata.com/support/statalist/faq 
*   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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