- clear
- input str60 case
- "1 reviews 2 hotel reviews 3 helpful votes"
- "1 re 2 hotel 3 helpful vote"
- "1 reviews 2 hotel s 3 helpful votes"
- end
- replace case = itrim(case)
- gen idd = reverse(case)
- gen zip1 = regexs(0) if(regexm(case, "[0-9]"))
- gen zip2 = regexs(0) if(regexm(case, ".[0-9]"))
- gen zip3 = regexs(0) if(regexm(idd, ".[0-9]"))
- gen id1 = strpos(case,zip1)
- gen id2 = strpos(case,zip2)
- gen id3 = strpos(case,zip3)
- gen length1 = length(case)
- gen case1 = substr(case,id1 + 1,id2 - 1)
- gen case2 = substr(case,id2 + 1 + 2,(id3 - 1)-(id2 + 1))
- gen case3 = substr(case,id3 + 1 + 2,.)
- keep case case1 case2 case3
- list
- . list
- +----------------------------------------------------------------------------------------+
- | case case1 case2 case3 |
- |----------------------------------------------------------------------------------------|
- 1. | 1 reviews 2 hotel reviews 3 helpful votes reviews hotel reviews helpful votes |
- 2. | 1 re 2 hotel 3 helpful vote re hotel helpful vote |
- 3. | 1 reviews 2 hotel s 3 helpful votes reviews hotel s helpful votes |
- +----------------------------------------------------------------------------------------+