Remove "weird" mixed names

[Jae Li]

Hello everyone! I'd like to quickly remove those weird company names: "number + customers" in my data. My original code is to find each one of them and type in a long list of codes. Any efficient codes to achieve the same goal? Thank you!

 cnms
38 Customers
4 companies
4 customers
39 Customers
43 CUSTOMERS
3900 Customers
392 Customers

[George Ford]

g cnms2 = substr(cnms,1,strpos(cnms, " ")-1)

[Nick Cox]

word(cnms, 1)

would also work. You might also want to make it numeric with real().

[Roman Mostazir]

Another approach:

g code = ustrregexs(0) if ustrregexm(cnms, "[0-9]+")

[George Ford]

#3. Of course.

[Jae Li]

Hi everyone, the issue was resolved! Thank you so much for contributing the brilliant ideas! Have a good weekend!