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

st: RE: retrieving a three-letter word from a string variable

From   "Dev Vencappa" <>
To   <>
Subject   st: RE: retrieving a three-letter word from a string variable
Date   Fri, 28 May 2004 16:11:07 +0100

Many thanks. This is working fine.


>>> 05/28/04 04:04pm >>>
One way to do this is 

gen whatever = "HMV" if index(myvar, "HMV") 

If you're fond of -cond()- you might prefer

gen whatever = cond(index(myvar, "HMV"), "HMV", "") 

Neither is a retrieval solution, but the 
result is the same. 

Another way to do it is through retrieval: 

gen whatever = substr(myvar,index(myvar, "HMV"),3) 
	if index(myvar, "HMV") 

but I can't see any advantage to that. 


Dev Vencappa

>  I have a dataset that contains several string variables. 
> Suppose one string variable contains the following values in 
> one of the observations:
> Another string variable contains :
> I want stata to create a new variable that retrieves only the 
> three-letter word "HMV" from the string variable. I 
> understand that the substr command does that but because the 
> starting point of the word HMV is not the same for every 
> variable , it would be difficult to identify the correct 
> starting position to read the string and retrieve the first 
> three letters HMV. 
> Can somebody help please? I have tried the other string 
> commands but could not understand one that does what I want.

*   For searches and help try:

This message has been scanned but we cannot guarantee that it and any
attachments are free from viruses or other damaging content: you are
advised to perform your own checks.  Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index