Taking numbers out of a string

[Rollo_Wenlock]

I have a location area from an address, but it has the zip code baked in. I need to take the numbers out of the data. Example; ‘Christchurch 8023’ → make it ‘Christchurch’

[ThinhDinh]

You can do something like this.

[Rollo_Wenlock]

That’s great thank you. It works really well except for entires with multiple words. Is there an update to the regular expression that will take care of this? cheers

[Robert_Petitto]

Here’s an alternative way using a Math columns and Replace All column:

[ThinhDinh]

Here you go.

[Rollo_Wenlock]

I added a space after A-Z like this and it worked out ([a-zA-Z ]+)

[ThinhDinh]

Theoretically your solution will work with space characters, but if you have tabs or line breaks then I believe \s covers them.