replacing brackets with parentheses in every column title with regex or any formula

AshaCharis

Hi, I am trying to replace all brackets with parentheses in the columns titles of my excel sheet.

so title for each column looks like this to what I want:

amb t [c] --> amb_t(c)

amb t [f] --> amb _t(f)

t [s] --> t(s)

etc.

Can anyone help with this? this is my first time using regex to replacing special characters.

Reporting

Regex

Help

Accepted answers

atcodedog05

Hi @AshaCharis

Use the formula in the dynamic replace tool like below.

Workflow:

Hope this helps : )

brackets.yxmd

All comments

atcodedog05

Hi @AshaCharis

You can use a formula like below

Replace(Replace([Input], "[", "("), "]", ")")

Hope this helps : )

brackets.yxmd

Maskell_Rascal

As it has been pointed out to me recently that there is a contingent of those that want REGEX answers and only REGEX answers, I will offer an alternative solution using REGEX_Replace. This one is for you @apathetichell! 😁

REGEX_Replace([Input], '(\[)(.+)(\])','\($2\)' )

And once again the chaotic spirits of REGEX have been appeased.

Cheers!

Phil

atcodedog05

It says also any formula.

But you make a fair point @Maskell_Rascal 😎.

AshaCharis

Thank you guys for the quick responses! my problem is that the titles I am looking at are in the actual field/record title.

So Input = amb_t[c] --> amb_t(c)

How do I make replace the column titles with parentheses without using the select tool to change every single one? (Lots of titles need to be replaced)

atcodedog05

Hi @AshaCharis

Use the formula in the dynamic replace tool like below.

Workflow:

Hope this helps : )

brackets.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703