Trim end of a string - help

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 (####)

Regex

Accepted answers

try this formula

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

Workflow:

Hope this helps : )

trim chars.yxmd

All comments

try this formula

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

Workflow:

Hope this helps : )

trim chars.yxmd

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

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

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 : )

trim chars.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703