[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: retrieving a three-letter word from a string variable
How about if you count the letters from the end instead of from the front?
The description for -substr- says:
substr(s,n1,n2) returns the substring of s starting at n1 for a length of n2.
If n1<0, the starting position is interpreted as distance from the end of the
string. If n2 is missing (.), the remaining portion of the string is
Now it might work if you write:
gen str3 threeletters=substr(originalstring,-4,3)
Hope it helps.
Dev Vencappa wrote:
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.
Department of Economics
University of Aberdeen Business School
Edward Wright Building F55
Tel: +44 1224 273417
Fax: +44 1224 272181
* For searches and help try: