Trying to remove part of a string from text in a column

Question

Hello,

I am trying to remove a portion of text in a string in a column of data. I have tried different methods and tools and have struck out and I guess I am just missing something. I want everything after the open parentheses gone. There is no consistency in the number of characters that may before a "(" and just need everything after it removed. I have tried with the column as a V_String and as a String, though not sure if it makes a difference.

Here is an example of what I am dealing with and where i want to end up:

A file of the data is attached. Any help is greatly appreciated.

Thanks,

Kevin

Data Example.xlsx

KBBear · Answer

Awesome! Two excellent solutions. Thank you guys so much! Knew there was a better mouse trap out there.

binu_acs · Answer

@KBBear another option using sub string function and the find string function

SubString([Data],0, FindString([Data], '('))

Luke_C · Answer

Hi @KBBear

Use a left function paired with a findstring function.

LEFT([Field1],FindString([Field1],'('))