Trim part of text field

[Sailor]

Hi

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

[patrick_digan · Accepted solution]

@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")

[pcatterson]

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

[Sailor]

Hi

Thanks a lot, it works fine

/Mats

[Sailor]

Hi

Thanks, works fine. I got one solution before yours

Regards Mats