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
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.
Hi @KBBear
Use a left function paired with a findstring function.
LEFT([Field1],FindString([Field1],'('))
@KBBear another option using sub string function and the find string function
SubString([Data],0, FindString([Data], '('))
Awesome! Two excellent solutions. Thank you guys so much! Knew there was a better mouse trap out there.