AnsweredAssumed Answered

Exclude text if found in a field

Question asked by ZacherieWalker on Mar 6, 2015
Latest reply on Mar 10, 2015 by ZacherieWalker

Title

Exclude text if found in a field

Post

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.  

Outcomes