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

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

From   Ada Ma <>
Subject   Re: st: retrieving a three-letter word from a string variable
Date   Sat, 29 May 2004 17:32:56 +0100

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:

Dear users,

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.

Many thanks

Ada Ma
Research Assistant
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:

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