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: RE: extracting a specific portion of a string
From
[email protected]
To
[email protected]
Subject
Re: st: RE: extracting a specific portion of a string
Date
Thu, 17 Mar 2011 06:42:23 -0400 (GMT-04:00)
Wouldn't it be simpler to rename "MOTHER'SBLOOD" "BLOOD,MATERNAL"?
reg
-----Original Message-----
>From: Eric Booth <[email protected]>
>Sent: Mar 17, 2011 12:15 AM
>To: "<[email protected]>" <[email protected]>
>Subject: Re: st: RE: extracting a specific portion of a string
>
><>
>
>On Mar 16, 2011, at 10:43 PM, Travis Coan wrote:
>>
>> I would take a look at the -substr- function -- typing 'help substr' should get you there.
>>
>
>You should probably look at all the functions available in -help string_functions-.
>Note that -substr- alone wouldn't return the desired result in this example, e.g.:
>
>**********************!
>clear
>inp str20(v1)
>"BLOOD"
>"BLOOD(LIPEMIC)"
>"BLOOD(MODERATELYLY"
>"BLOOD, 2ND SPECIMEN"
>"BLOOD,1STSPECIMEN"
>"BLOOD,2NDSPECIMEN"
>"MOTHER'SBLOOD"
>"SERUM,1STSPECIMEN"
>"SERUM,2NDSPECIMEN"
>end
>
>g v2 = substr(v1, 1, 5)
>**note obs 7
>
>//using strpos and substr string functions//
>g str10 v4 = ""
>foreach x in "BLOOD" "SERUM" {
>g v`x' = strpos(v1, "`x'")
>replace v4 = substr(v1, v`x' , 5) if v`x'>0
>}
>
>//using index//
>g ind = 0
>replace ind = 1 if index(v1, "BLOOD")
>replace ind = 2 if index(v1, "SERUM")
>la def ii 1 "Blood" 2 "Serum", modify
>lab val ind ii
>li
>**********************!
>
>- Eric
>__
>Eric A. Booth
>Public Policy Research Institute
>Texas A&M University
>[email protected]
>
>
>>
>>
>> From: [email protected] [mailto:[email protected]] On Behalf Of Mendoza Aldana, Dr Jorge Antonio (WPRO)
>> Sent: Wednesday, March 16, 2011 10:36 PM
>> To: [email protected]
>> Subject: st: extracting a specific portion of a string
>>
>> Dear all,
>> My dataset has a string variable, from which I need a specific portion of it. The content of the variable is like:
>>
>> BLOOD
>> BLOOD(LIPEMIC)
>> BLOOD(MODERATELYLY
>> BLOOD, 2ND SPECIMEN
>> BLOOD,1STSPECIMEN
>> BLOOD,2NDSPECIMEN
>> MOTHER'SBLOOD
>> SERUM,1STSPECIMEN
>> SERUM,2NDSPECIMEN
>>
>> and I need to generate a new variable containing either "BLOOD" or "SERUM"
>> I would appreciate very much if you can give me some hints on solving this.
>> I'm using Stata 11.1 on a Windows XP machine
>> Kind regards,
>> Jorge
>>
>>
>>
>>
>> ====================================================
>> This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.
>>
>> Disclaimer:
>>
>> This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.
>>
>> If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.
>>
>>
>> *
>> * 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/
>> ________________________________________
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 10.0.1204 / Virus Database: 1498/3510 - Release Date: 03/16/11
>>
>> *
>> * 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/
*
* 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/