regex_replace keep the brackets

[dlesny]

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]

Hi @dlesny 

Wouldn't this work better?

"Enabler: (BC1.4.9) " + [Field]

Cheers,

[Thableaus · Accepted solution]

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 solution]

Hello @dlesny 

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

[dlesny]

@Thableaus  Many times the [Field] also changes. Thank you for RegEx that would work.

@CharlieS That is much better idea, Thank you! :)