Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: Extracting substrings from variables.
From
Amal Khanolkar <[email protected]>
To
"[email protected]" <[email protected]>
Subject
RE: st: Extracting substrings from variables.
Date
Fri, 25 May 2012 13:31:09 +0000
Thanks Brendan - it worked like a charm! :)
Nick - I tried your way using 'inlist' however I kept getting an error message that one bracket was missing - I tried several ways to try and solve the issue - but was unable to do so - any ideas?
I agree with both of you - regexs can be annoying esp for me who came across it for the first time today :)
Thanks!
/Amal.
________________________________________
From: [email protected] [[email protected]] on behalf of Brendan Halpin [[email protected]]
Sent: 25 May 2012 14:07
To: [email protected]
Subject: Re: st: Extracting substrings from variables.
On Fri, May 25 2012, Brendan Halpin wrote:
> On Fri, May 25 2012, Amal Khanolkar wrote:
>
>> gen preght = regexs(0) if regexm(mdiag1x, "[^637] | [^642] | [^O1]")
>
> A quick and untested suggestion:
>
> . gen preght = regexs(0) if regexm(mdiag1x, "^(637)|(642)|(O1)")
On testing, it seems the grouping parentheses are not necessary:
...................................................................
. input str10 mdiag1x
mdiag1x
1. "637 asdf"
2. "638 asdf"
3. "8637 asdf"
4. "642 asdf"
5. "O1 asdf"
6. end
. gen preght = regexs(0) if regexm(mdiag1x, "^637|642|O1")
(2 missing values generated)
. gen hasdiag = regexm(mdiag1x, "^637|642|O1")
. list
+------------------------------+
| mdiag1x preght hasdiag |
|------------------------------|
1. | 637 asdf 637 1 |
2. | 638 asdf 0 |
3. | 8637 asdf 0 |
4. | 642 asdf 642 1 |
5. | O1 asdf O1 1 |
+------------------------------+
...................................................................
Brendan
--
Brendan Halpin, Department of Sociology, University of Limerick, Ireland
Tel: w +353-61-213147 f +353-61-202569 h +353-61-338562; Room F1-009 x 3147
mailto:[email protected] ULSociology on Facebook: http://on.fb.me/fjIK9t
http://teaching.sociology.ul.ie/bhalpin/wordpress twitter:@ULSociology
*
* 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/
*
* 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/