Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Nick Cox <n.j.cox@durham.ac.uk> |
| To | "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> |
| Subject | RE: st: RE: strings |
| Date | Wed, 1 Feb 2012 12:44:08 +0000 |
I can't tell what you thought of but didn't tell us! More seriously: Please read the help for -string functions-. It tells you about -upper()-, -lower()-, -proper()- and more besides. It's _functions_ here first, not commands. Nick n.j.cox@durham.ac.uk KOTa > NJC>>> That's not really a -split- problem. "INC" is not a string separator here. I am credited as the original author of -split- so I can tell you that it was not designed for this. > > The easiest recipe (!) I can think of is > > gen reversed = reverse(company) > replace reversed = subinstr(reverse, "CNI ", "", 1) if substr(reversed, 1, 4) == "CNI " > replace company = reverse(reversed) that is how i also thought to do it (without reverse, just checking if last 3 are "INC"), but hoped for an easier/clear way existance > NJC>>> In general, you have to clean up inconsistencies before -merge-. -merge- has a difficult enough job as it is! thus, probably something to make strings all upper cases is a solution, if there is such string command * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/