Can`t remove all text to the right of a "("

[dschmitt]

below is a script that removes a parentheses. How do I need to change this script so that all text to the right of the parentheses including the parentheses is removed?
For example: "John Dow(Planning Department)" changed to "John Dow"

Please Login or Register  to view this content.

[rkey]

Hi Dschmitt,

I would use something like this

Please Login or Register  to view this content.

[buran]

Here are my 2 cents

Please Login or Register  to view this content.

Buran

[dilipandey]

Hi dschmitt,

Play with Left function instead of substitute, see below code:-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

[dschmitt]

thank you rkey. That worked.

[dschmitt]

thank you buran and dilipandey. Your scripts work equally well.
Who would have thought that I get within 5 minutes threee different methods.
Great

[dilipandey]

Cheers


Good to hear that...

Regards,
DILIPandey

<click on below 'star' if this helps>