Remove Parenthesis and their Contents

[dmcgetti]

I am just starting to dabble in Access and I need to remove any parenthesis and their contents from my field "CustomerName". In Excel I would do a Find and Replace of "(*)", but that does not seem to work here.

Thanks as always!

 

[Joe4]

Please post some examples of your data and expected results.
If you may have different scenarios (i.e. parentheses showing up in different places, multiple times, or not at all), please be sure to include those cases in your examples.

 

[dmcgetti]

My apologies...

Here is what my data sheet currently looks like:

CustomerName
MIKES AUTO REFINISHING (C60)
MIKES AUTO REFINISHING (C60)
CALIBER - GLENOLDEN #3709 (W60)
MOPPERT BROTHERS AUTO COL
CALIBER - GLENOLDEN #3709 (W60)
KEN STOCKER AUTO BODY
BUCKINGHAM COLLISION & TOWING SERVI
BUCKINGHAM COLLISION & TOWING SERVI
BUCKINGHAM COLLISION & TOWING SERVI
MAACO BRIDGEPORT (W60)
MAACO BRIDGEPORT (W60)

<caption> Sales </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>

And this is what I would like it to look like:

CustomerName
MIKES AUTO REFINISHING
MIKES AUTO REFINISHING
CALIBER - GLENOLDEN #3709
MOPPERT BROTHERS AUTO COL
CALIBER - GLENOLDEN #3709
KEN STOCKER AUTO BODY
BUCKINGHAM COLLISION & TOWING SERVI
BUCKINGHAM COLLISION & TOWING SERVI
BUCKINGHAM COLLISION & TOWING SERVI
MAACO BRIDGEPORT
MAACO BRIDGEPORT

<caption> Sales </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>

 

[james_lankford]

I know you can use a vba function with regex and update that field, but you'll have to figure out the actual code yourself or get some help

https://www.google.com/search?q=vba.....69i57j0l5.2367j0j7&sourceid=chrome&ie=UTF-8

 

[Joe4]

You can use an Update Query to remove it, like this:

UPDATE Table1 
SET Table1.CustomerName = Trim(Left([CustomerName],InStr([CustomerName],"(")-1))
WHERE InStr([CustomerName],"(")>0;

You can copy and paste this into a new query, by switching the SQL View in the Query Builder.
Just substitute Table1 with the name of your Table.