SQL parse parens and contents in between

Looking to strip out parenthesis (and contents) in a product's description.

For example:

Chocolate 0.6m (1.96 ft.) Braided

Chocolate Braided

would also like to strip out the "0.6m" if possible too.

Any ideas?
Who is Participating?
sdstuberConnect With a Mentor Commented:
oops, missed the "also" part

how is that identified?  the word immediately preceeding the parenthentic section?

if so, try this...

regexp_replace(yourstring,' .+ \([^)]+\)')

if that's not the rule, please explain how to identify which pieces of your string stay and which are removed
regexp_replace(yourstring,' ?\([^)]+\)')
slightwv (䄆 Netminder) Commented:
Is it always first and last word?

What are some of the other terms that need stripped?

More sample data and expected results would help a lot.
globalwm2Author Commented:
Thanks - I can work with this for my needs.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.