extract nubers before string

[ohruud]

Hi there, 

I am not particularly good with regex, and I need som help. 

In my data, I have a field comprised with both numbers and string. I want to extract the number (including the space between the numbers, and get rid of the other characters. 

This is the format of the field:

"222 57 03 00 Institute for economics, marketing and law"

Any help ? 🙂

Best regards

[ohruud · Accepted solution]

Managed it my self.  Used REGEX_Replace([Field],"[^\d\s]","")