Dear STATAlisters,

I have a column of text, which also contains number(s). It has some peculiarities. First, the number’s length can vary from 1 to 5 digits. Second, the number can be all numeric or alphanumeri, but if it is alphanumeric, it usually has alphabets in the first or last place. Third, the text can contain more than one number.

I tried splitting the text using space as delimiter but it resulted in more than 100 variables as the text can be long for some observations.

How should I tackle such issue? Any guidance will be much much appreciated.

Thanks.

Lg Mg