Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: trimming leading numbers from a string.


From   Philip Ryan <philip.ryan@adelaide.edu.au>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: trimming leading numbers from a string.
Date   Tue, 23 Sep 2008 16:23:20 +0930

Try:

gen cname_2 = trim(regexr(trim(cname), "^[0-9]", ""))


http://www.ats.ucla.edu/stat/stata/faq/regex.htm  is especially helpful


Phil



At 03:28 PM 23/09/2008, you wrote:
ahhh I get you. I was thinking more in terms of "detecting" a number
and replacing it with a space and then trimming. But Thank You for
your reply.

Is there a way to say ALL except the 1st word ? That would be very
useful cos sometimes I have " 0 Andhra Pradesh ".

Thank you,
Ashim.

On Tue, Sep 23, 2008 at 11:13 AM, Matt Spittal
<Matt.Spittal@cancervic.org.au> wrote:
> Ashim,
>
> You can use the string functions, see -help string functions- to extract the information that you want. For instance
>
> generate place = word(cname, -1)
>
> will return the last word in the variable cname. Similarly,
>
> generate place = word(cname, 2)
>
> will return the second word (although this may not be what you want as there is only one word in your first example).
>
> -- Matt
> matt.spittal@cancervic.org.au
>
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Ashim Kapoor
> Sent: Tuesday, 23 September 2008 3:07 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: trimming leading numbers from a string.
>
>
> Hello everyone,
>
>
> I have a string variable called "cname".
>
> It looks something like this.
>
> cname
> 1. DELHI
> 2. 0 HYDERBAD
> 3. 1 USA
> 4. 4 AP
>
> I want to remove the leading 0 / 1 / 4 / other numbers from this
> string and keep only the alphabets. Is there a do file someone has
> written on this ?
>
> Thank you,
> Ashim.
Philip Ryan
Discipline of Public Health
University of Adelaide 5005
South Australia


*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index