Dynamic rename with regex

can someone please help with the expression to replace the spaces after the numbers with a dash using RegEx? this is going into a dynamic rename tool. thanks!

Example:

Before:

1234 4545 Building

334343 34345 Car

938 34343 Equipment

After:

1234-4545 - Building

334343-34345 - Car

938-34343 - Equipment

Regex

Accepted answers

Thableaus

@cireost

If the pattern always consists of two sequences of digits (with whitespace in between), whitespace and anything else.

You can set this: REGEX_Replace([Field1], "(\d+)\s+(\d+)\s+(.*)", "$1-$2 - $3")

Cheers,

All comments

Thableaus

Hi @cireost

REGEX_Replace([Field], "\s", "-")

This should work.

Cheers,

cireost

@Thableaus sorry missing one detail.

some of the text are two words so I only want the dashes in between the numbers and after the numbers. but not in between the words. thanks!

Before:

3934 3493 New Building

After

3934-3493 - New Building

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335