regex_replace keep the brackets

Question

Hello

I am trying to use Regex_replace () formula and I need to replace this:

Acceptance Criteria (GWT)

with that:

Enabler: (BC1.4.9) Acceptance Criteria (GWT)

This is the Formula I am using but it ignores the brackets: So instead of this: Enabler: (BC1.4.9) Acceptance Criteria (GWT) I get: Enabler: BC1.4.9 Acceptance Criteria GWT.

Well not exactly in this example, as it also ignores the brackets from the first part of the Formula but in general.

regex_replace([ACTIVITIES],"Acceptance Criteria (GWT)", "Enabler: (BC1.4.9) Acceptance Criteria (GWT)")

Thableaus · Accepted Answer

Also, the correct version would be:

regex_replace([ACTIVITIES],"Acceptance Criteria $GWT$", "Enabler: $BC1.4.9$ Acceptance Criteria $GWT$")

The parenthesis need to be escaped, since they are special characters.

Cheers,

CharlieS · Accepted Answer

Hello @dlesny

Have you thought about going the Find Replace route? Check out the attached workflow for an example.