Trim part of text field

I am struggling to solve this problem. I do a lot of data prep and blending but have not solved this problem.

Original string:

125 58 Stora Mossen

Desired string:

12558 Stora Mossen

If I use trim, all spaces are removed. I can not find any suitable regex_replace pattern

Regards Mats

Accepted answers

@Sailor The below will work if you have one or more digits separated by one or more spaces.

regex_replace([Field1],"(\d+)\s*(\d+)","$1$2")

@Sailor The below will work if you have one or more digits separated by one or more spaces.

regex_replace([Field1],"(\d+)\s*(\d+)","$1$2")

If you want to remove the space in between sets of numbers, you can do that like this:

Thanks a lot, it works fine

/Mats

Thanks, works fine. I got one solution before yours

Regards Mats