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

[KBBear]

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

[JosephSerpis]

Hi @KBBear one approach to tackle this is use a Text to column tool and use ( as a delimeter to spilt the column. I mocked up an approach. You could also use Regex as another approach.

[Luke_C]

Hi @KBBear 

Use a left function paired with a findstring function. 

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

[binuacs]

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

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

[KBBear]

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