To always add a space before every "("

Hello everyone!

Just wondering if anyone knows how to add a space before every occurrence of a "(" that is directly attached to a word without a space?

For example:

Amanda does not have a space before "(", so we should add one space for her, while Eric remains as it is:

Student Info	Updated Student Info
Eric (12345)	Eric (12345)
Amanda(45678)	Amanda (45678)

Thank you in advance 😍

Designer Cloud

Accepted answers

AgusEP

something like this?

Spoiler

KGT

REGEX is the quickest and most succinct for a one tool solution, however you can make it more "explainable" with the below:

You could filter the data looking for Contains([Student Info],' (').
The false will then give you all the records that don't contain the space/bracket combo.
A formula to replace([Student Info],"("," (") should then put a space before each open bracket.
Union to bring it back together.

The REGEX replace in the regex tool would be something like ([A-z])(\() with Replacement Text being $1 \( if you wanted to go that way.

Note: Sorry I just noticed this is tagged Designer Cloud. I'm not totally sure the above will work in Designer Cloud as I don't know the product, but my answer is relevant to Designer Desktop.

All comments

AgusEP

something like this?

Spoiler

KGT

REGEX is the quickest and most succinct for a one tool solution, however you can make it more "explainable" with the below:

You could filter the data looking for Contains([Student Info],' (').
The false will then give you all the records that don't contain the space/bracket combo.
A formula to replace([Student Info],"("," (") should then put a space before each open bracket.
Union to bring it back together.

The REGEX replace in the regex tool would be something like ([A-z])(\() with Replacement Text being $1 \( if you wanted to go that way.

Note: Sorry I just noticed this is tagged Designer Cloud. I'm not totally sure the above will work in Designer Cloud as I don't know the product, but my answer is relevant to Designer Desktop.

quinnteoh

Both methods work perfectly!

Thank you all so much 😍

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703