How to replace two or more white spaces with a single white space?

Here is the situation,

There are two white spaces before '-' in the first line where as there is only one white space in the second line. How do I get rid of two white spaces in the first line?

2018 Small North Chart - GRE

2018 Small South Chart - GRY

Thank You

Developer Tools

Help

Expression

Accepted answers

tlarsen7572

Use this in a formula tool:

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

The \s+ pattern matches one or more whitespace characters, which all get replaced by a single space.

All comments

tlarsen7572

Use this in a formula tool:

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

The \s+ pattern matches one or more whitespace characters, which all get replaced by a single space.

BenMoss

I'm going to go simpler than that; check out the data cleanse tool and there is an option to trim duplicate whitespace!

Ben

MarqueeCrew

Ben,

Under the covers, that is the formula being used.

dkchandana3

Used a similar one.

Thank You

dkchandana3

Thank You!

uips

Great answer. What if there was "A&B 5 000,01" and would like to see "A&B 5000,01"? How would you do that?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703