How to remove parentheses and their content from a string

I am completely new at Alteryx (~2 weeks) and am still trying to get familiar with all of the tools. I have some data in the following format:

Product Name (Customer Info) Product Description

I am trying to get the following:

Product Name Product Description

I have seen a couple of other questions and comments posted and one user suggested the following formula:

Regex_Replace([Field1]," \(.*?\)","")

I tried doing this. I made sure to replace [Field1] with the actual name of the column I'm trying to alter. The data preview shows output how I am expecting it (albiet without the space between Product Name and Product Description). However when I run the workflow it errors out completely and I get the error message below:

The field "" is not contained in the record. (Expression #1)

Regex_Replace([Field1]), " \(.*?\)","")

Does anyone know what I am doing wrong.

Tips and Tricks

Documentation

Accepted answers

You need to create a new field in the formula tool to store the output (or select to overwrite Field1)

Select a column or Add A column in the shown drop down and error should go away

The expression you have should produce the output you want then I think.

All comments

EDIT: @jdunkerley79 addressed the real issue. Nice work.

You need to create a new field in the formula tool to store the output (or select to overwrite Field1)

Select a column or Add A column in the shown drop down and error should go away

The expression you have should produce the output you want then I think.

This did the trick. I needed to specify the new output column. Thank you so much for taking the time to answer!

Quick Links

Tags

This months top contributors

Hollingsworth 335