Exclude text if found in a field
I'm writing a script to evaluate a group of fields and a problem I've been having is excluding certain "phrases" and the text that follows it. In this case, I'm trying to look for any "NOTES" that could be found in a field and exclude everything that follows it.
I'm still a bit new to the text parsing and I haven't been able to quite figure it out. Is this possible or am I just too hopeful thinking?
Also, things to consider: The notes could be found anywhere within the fields the script is evaluating. It's a typical practice to put notes at the end of the field. All the text before the note is typically important and will be used 95% of the time, given a couple situations where it wouldn't.