Trim end of a string - help

[mikedesena]

Hello, here are examples of my data set:

Abcd Inc. (1234)

A Bcd llc (6789)

Abcd(4567)

I want to trim off the (####) from the right and keep no blank spaces. I have tried to follow regex examples but just do not understand it well enough yet. Can anyone help me out? The ending is always (####)

[atcodedog05 · Accepted solution]

Hi @mikedesena 

try this formula

REGEX_Replace([Field1], "\s?\(.+\)", "")

Workflow:

Hope this helps : )

[mikedesena]

I don't know how your sorcery works but it did. Could you do a step by step for me? As well i only have 2 errors now that there are trailing spaces. Those items were set up like:

ABC LLC   (1234)    (3 spaces)

XYZ Inc  (7894)   (2 spaces)

   
Should I just do a cleanse after? Thank you so much

[mikedesena]

I don't know how your sorcery works but it did. Could you do a step by step for me?

As well i only have 2 errors now that there are trailing spaces. Those items were set up like:

ABC LLC (1234) (3 spaces)

XYZ Inc (7894) (2 spaces)

Should I just do a cleanse after? Thank you so much

[atcodedog05]

Hi @mikedesena 

I have modified the formula to meet the requirement.

REGEX_Replace([Field1], "\s*\(.+\)", "")

Workflow:

Explanation: 

Remove character pattern

\s* zero or more spaces

\( followed by open bracket

.+ any character inside bracket

\) followed by closed bracket.

Hope this helps : )