Regex for single space

Question

I'm trying to match a file which is delimited by multiple spaces. The problem I have is that the first field can contain a single space. How can I match this with a regex? Eg: ``` Name Other Data Other Data 2 Bob Smith XX1 0101010101 John Doe XX2 0101010101 Bob Doe XX3 0101010101 John Smith XX4 0101010101 ``` Can I split these lines into three fields with a regex, splitting by a space but allowing for the single space in the first field?

Accepted Answer

Hi the following regex should work

```
(\w*\s\w*)\s+\w{2}\d\s+\d*
```

Regex for single space

Solution

Problem