Excellent.
Replacing trailing zeros looks like
reverse(substr(reverse(x), indexnot(reverse(x), "0"),.))
Nick
[email protected]
Jamie Griffin
> To remove leading zeros from the string variable x without
> looping, how
> about:
>
> replace x=substr(x, indexnot(x, "0"), . )
> >>> [email protected] 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
> [email protected]
>
> >>> 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/
