Creating RegEx For Replace

[jerrybo]

I have a RegEx question. I have a Composer field in the format of Name (1234 - 5678). What I need is a ReegEx, or something similar, to edit the field to just Name, (deleting the (...).

I use regex in .NET but for some reason I cannot develop this string.

Jerry B

[ohrenkino]

You could try:
$regexp('Name (1234 - 5678)','\s*\(.*',)
or
$regexp(%composer%,'\s*\(.*',)

[jerrybo]

Thanks ohrenkino.

That is a lot simpler than the command I was coming up with.

Jerry B